Re: What is the best way to copy 2G table data between two databases

"Ron" <support_at_dbainfopower.com> wrote in message news:<ipCdnUyQAO_LLbLdRVn-sw_at_comcast.com>...
> Hello David,
>
> Also, you can use transportable tablespaces approach ( requires
> maintenance window since tablespace should be placed into r/o mode, IMHO -
> would not use it for 2GB)

create a new user with a new tablespace that it defaults to. Create table as nologgign by this user. Transport that user. No downtime.

Easiest method is to just use a DB-Link create table as nologging. The create your indexes in parallel(all at the same time) with either using dbms_job, cronjob or opening a bunch of sqlplus sessions.

>
> #2 is a good one
>
> ( for better performance (if machine resources allows) you can
>
> 1) parallelize inserts by adding parallel hint (don't forget "alter
> session enable parallel dml" )
>
> 2) add parallel hint to select to minimize impact on production
> )
>
> Regards,
>
> Ron
> DBA Infopower
> http://www.dbainfopower.com
> Standard disclaimer:
> http://www.dbainfopower.com/dbaip_advice_disclaimer.html
>
>
>
> "David" <david_at_david.nospam.com> wrote in message
> news:c0o8uh$a8717_at_imsp212.netvigator.com...
> > Hi all,
> >
> > I want to copy all data from a table (which is about 2G size) from
> > database A to B (both are 8.1.7, archive log mode, but on different
> server).
> > What is the safest and fastest way to do this? I have some options:
> >
> > 1) exp/imp
> > 2) insert /*+ append */ with nologging, with database link
> >
> > Which option is better? Or any other ways?
> >
> > Thanks,
> > David
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
Received on Mon Feb 16 2004 - 13:15:57 CST