Re: Suggestion on moving large amount of data from two databases

The biggest problem with export/import is that there is no way to avoid generating rollback during the insert. If the 2 databases are in the same data center (i.e., the network is not a problem), then the fastest method of copying data is:

CREATE TABLE local
NOLOGGING
<storage clause, if you want>
AS
SELECT * FROM remote_table_at_remote_service ;

Sometimes this is even the best method for networked sites.

Richard Sutherland
rvsutherland_at_yahoo.com

Jimmy <anonymous_at_anonymous.com> wrote in message news:3A5852BD.610C3ABA_at_yahoo.com...
> HI all,
>
> I have two databases A and B (two identicial databases, but with
> different sizes). Database A has about 50-70G data files. Database B has
> about 20G data files. I want to transfer data (about 10G) from A to B on
> daily basic. What are the efficient ways of doing this? We cannot alter
> any structures in database A since this database is provided by another
> company. We can only do export on this database.
>
> Thanks,
> David
Received on Mon Jan 08 2001 - 16:26:28 CST