Re: Loading Data...

steve wrote:

> 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....

Your problem could be easily and efficiently resolved by SQL*Loader, a standard utility which comes with import, export, etc. Basically you have to describe in a control file the format of the records in the flat file and this utility will scan the flat file and load data in the table you choose. If time is a critic variable of your problem try using the direct path option which bypass the SQL engine and speeds up the process.

>
> 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???)

As far as I can understand the semantic of the statement, I think in Oracle you should use:

  UPDATE A SET A.X=(SELECT B.Y FROM B WHERE A.KEY = B.KEY) --
Stefano Spelta

HDT Team
in consulenza presso CSELT (Centro Studi e Laboratori Telecomunicazioni) mailto:stefano_at_caino.cselt.it Received on Wed Mar 17 1999 - 05:19:11 CST