Re: Export Import Large Database - 9i
From: Greg Rahn <greg_at_structureddata.org>
Date: Sat, 16 Jan 2010 10:32:10 -0800
Message-ID: <a9c093441001161032i6255502aoa89d039c56dc217b_at_mail.gmail.com>
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.
Date: Sat, 16 Jan 2010 10:32:10 -0800
Message-ID: <a9c093441001161032i6255502aoa89d039c56dc217b_at_mail.gmail.com>
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_at_gmail.com> 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-lReceived on Sat Jan 16 2010 - 12:32:10 CST