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

Forget import export. Spool the data off as text files and bring it in using DIRECT PATH and SQL*Loader.

If you know the data is clean drop all indexes and constraints and then rebuild them after the load is complete.

Dan Morgan Received on Tue Jan 09 2001 - 00:37:42 CST