Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Loading Data...
try to load with the oracle utilitie sqlloader
steve schrieb in Nachricht <7cl8gl$jvh$1_at_reader1.reader.news.ozemail.net>...
>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.
>
>I appreciate your comments and experience.
>
>steve.
>
>(Also; Is there an Oracle equivalent of the...
>
>UPDATE A SET A.X = B.X FROM B WHERE A.KEY = B.KEY
>
>statement I used to use in Sybase???)
>
>
Received on Wed Mar 17 1999 - 14:21:26 CST