Re: Which method: dblink or import/export?

I think more info is needed here. Are you retrieving information from multiple tables that requires joins, or is it just data from one table? I actually like using COPY since I don't need to worry about rollback space (too much) for that for large data transfers. Another method I like is to use PL/SQL (or even just good ol' SQL) to spool the data to a file, and use SQL*Loader to load the data into my local table (direct load, of course, for super-speedy loads!)

Hope that gives you some ideas!

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 Fri Apr 23 1999 - 00:31:14 CDT