Re: Moving data - EXPORT or COPY or SQLLOADER ???

In a DSS environment moving large volumes of data is a common practice.

I tend to favour dumping the data into OS files to then be used be SQL*Loader as this is the fastest way to get data back into a database as SQL*Loader can run parallel, direct and unrecoverable. I've managed to load 2million rows of data into a table in 4 minutes and build indexes in another 6 minutes, total load time 10 mins.

The only problems you face is how to unload the data. SQL*Plus is one option but parhaps a little slow. Look around at some of the Oracle sites on the net for a C program to unload the data, this would be more efficent.

on another point if you were to use export, you could perform your export via a pipe and compress it reducing the size of the dump file. The import process can be done in the same way, uncompress the file via a pipe to the import utility. I think there are examples of this in the Oracle Magazine Code Depot.

Regards,

Phil Received on Thu Jul 24 1997 - 00:00:00 CDT