Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: What is the best way to copy 2G table data between two databases
Hi Ron,
TTS seems not OK since the tablespace contains other tables. Both databases are on Solaris.
Thanks,
David
"Ron" <support_at_dbainfopower.com> wrote in message
news:R7idnbZ5S8jOJrLdRVn-vw_at_comcast.com...
> As well (unless 10g) :-)
>
> "DJ" <nospamplease_at_goaway.com> wrote in message
> news:VtOXb.6201$vo1.2926_at_newsfep4-winn.server.ntli.net...
> >
> > "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 - 14:35:09 CST