Loading Data...

From: steve <sjm26_at_hotmail.com>
Date: Tue, 16 Mar 1999 20:41:33 +1100
Message-ID: <7cl8gl$jvh$1@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 Tue Mar 16 1999 - 03:41:33 CST