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 - 12:39:15 CST
