Re: Uploading data into Oracle

The best tool for loading any Oracle database is SQL*Loader (Oracle Loader). There is a command line version of the program %Oracle_Home%\bin\Sqlldr80.exe or you my use Data Manager (%Oracle_Home%\BIN\VAD.EXE) which provides a GUI interface to IMP (Import), EXP (Export), and SQL*Loader (Oracle Loader). You would nominally setup a control file to handle either a fixed-length or a delimited data file. The Utilities Manual and Help files have a lot more information on this. Also Sqlldr80.exe /help=y list the parameters.

Mike Rose

MAMASTA wrote in message <19990208230056.10511.00000225_at_ng-ce1.aol.com>...
> What is the best tool for uploading data into oracle?
>We are considering Erwin or perhaps TOAD.
>Anyone had experience with these?
>Which is better?
>If not perhaps another tool?
>
>Seems like imp and exp are mainly used by SYSTEM or DBA.
>
>I tried insert statement but seems like you have to load at 10,000 record
>segements and tend to be slow in generating the sql statements.
>It took me a few days just to generate and load ~300,000 record database.
>
>There must be a much easier way than this....
>
Received on Tue Feb 09 1999 - 07:37:59 CET