Flat files upload/download [message #71033] |
Thu, 29 August 2002 03:31 |
Isabel
Messages: 2 Registered: August 2002
|
Junior Member |
|
|
Im running oracle 8i on a Unix environment.
Im constructing a system that will receive by ftp hundreads of ascci files (10kb, 300 records)and upload them to the oracle database. For each file received it is necessary to output another ascci file (that will be transferred by ftp as well).
Im thinking about using sql load to upload the information and sl*plus to generate the ascii files.
Im affraid that this would not be the best solution.
Do you have any idea about it? do you any product/solution for a 3nd vendor?
Thanks a lot for your attention,
Isa
|
|
|
Re: Flat files upload/download [message #71034 is a reply to message #71033] |
Thu, 29 August 2002 04:46 |
|
Mahesh Rajendran
Messages: 10707 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
it depends on how much money / effort /time you can afford.
we use sql*loader to loader to load data into our oracle tables.
similary, we extract data from oracle into flat files(for essabase/olap tools).
if the output is simple we just spool the output of query. else use UTl_file package. these
process handle typically a few hundred thousand records(daily process) and few million records( weekend process). Process works like a charm (eventhough it is slow, it is affordable for a medium terrabyte warehouse)
|
|
|