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

"Ron" <support_at_dbainfopower.com> wrote in message news:z72dnd6hZMQjL7Ld4p2dnA_at_comcast.com...
>
> one more note:
>
> After some consideration: use of TTS would make sense only if table
> occupies most of the tablespace and it is self-contained.
>
> So, you can ignore it if this is not your case.
>
>
> Regards,
>
> Ron
> DBA Infopower
> http://www.dbainfopower.com
> Standard disclaimer:
> http://www.dbainfopower.com/dbaip_advice_disclaimer.html
>
>
>
>
>
> "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)
> >
> > #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
>

and more importantly - same OS Received on Sun Feb 15 2004 - 12:01:25 CST