Re: Export Import Large Database - 9i

I think there are numerous "easy" ways to get the objects, etc over -
it's that data that presents challenges.  If you were on 10g or newer
then expdp/impdp would be one option (or as mentioned TTS).  Using
exp/imp forces a logging import which will create lots of redo and
will be much slower than a nologging load.  Unloading the database (or
at least large tables) to flat files could be an option - then load
back via parallel nologging direct path loads via external tables.
Tools like WisdomForce FastReader might come in very handy if this is
desirable.

On Sat, Jan 16, 2010 at 10:05 AM,  <troach@xxxxxxxxx> wrote:
> Might be a good time to try and convince the powers that be that this may be
> a good time to upgrade to 10g or 11g?

-- 
Regards,
Greg Rahn
http://structureddata.org
--
http://www.freelists.org/webpage/oracle-l

Other related posts: