While
utility to use and load files?
Q & A:
>I need to load a few of million
rows into an empty database (the biggest
>tables will require between
1 and 2 million each). The rows are currently
>sitting in flat files....
>
>What is generally the best
strategy for approaching this task. I have used a
>program called BCP under
Sybase that seemed to work pretty well - Is there
>an Oracle equivalent? Is
it any good?
>
>If I consider a row-by-row
approach using a c program is it likely to finish
>within the millenium? I will
be dropping all indexes and triggers before
>starting.
the program is sqlldr.
would recommend
- use the direct path mode
of the loader.
- put the database in noarchivelog
mode while loading (switch back to archive
log mode and backup after
the load)
- put indexes on after the
load (use unrecoverable and parallel index creation
if possible)
direct path mode is very similar
to bcp (but faster...) no triggers or
constraints will be fired