Re: Which method: dblink or import/export?

Here is the pat answer ... it depends.

What is a "large amount of data"? You should realive that imp/exp is relatively slowwwwww.

The dblink method may cause all your transactions to be logged (unless you are on Oralce 8 and using the direct insert method). Again, slowwww.

I w ould suggest using SQL*Plus to extract the data to a named pipe, and using that named pipe as input to SQL*Loader direct method. It sounds complicated, but it really isn't.

rr

Paschal Mushubi wrote:

> My task:
> Populating a table in a local Oracle database with
> data from a remote Oracle database:
> Which of these two methods is more efficient for
> transferring large amounts of data?
>
> Using database link:
> PL/SQL procedure opens cursor and selects data from a remote
> database then iserts them into a local database
>
> Import/Export:
> Dump data from a remote table into a dat file
> then ftp it to local machine and use sqlloader to
> insert the data.
>
> Other options?
> Suggestions, please.
>
> Regards.
>
> paschal.

Received on Thu Apr 22 1999 - 21:30:35 CDT