Re: Export Import Large Database - 9i

From: <troach_at_gmail.com>
Date: Sat, 16 Jan 2010 18:05:34 +0000
Message-ID: 1124216583-1263665076-cardhu_decombobulator_blackberry.rim.net-1663453303-_at_bda492.bisx.prod.on.blackberry>

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? Sent from my Verizon Wireless BlackBerry

-----Original Message-----
From: Oracle Dba Wannabe <oracledbawannabe_at_yahoo.com> Date: Sat, 16 Jan 2010 02:07:54
To: <dbvision_at_iinet.net.au>
Cc: <Oracle-L_at_freelists.org>
Subject: Re: Export Import Large Database - 9i

I should have mentioned this is cross platform - xtts came in 10gR1 unfortunately. Thanks

---

From: Nuno Souto <dbvision_at_iinet.net.au> Cc: Oracle-L_at_freelists.org
Sent: Sat, January 16, 2010 6:00:53 PM
Subject: Re: Export Import Large Database - 9i

Oracle Dba Wannabe wrote,on my timestamp of 16/01/2010 7:40 PM:
> Hi,
> Was wondering if anyone could share their experience of having to export import VLDB's in a 9i environment. For certains reason the database that I need to migrate cannot be upgraded - which would open up a lot more options. I'm hoping people out there could help with their personal experiences, if any, with respect to what they found helped the best during this process. I'd appreciate any input, thanks
> Thanks
>

Why do you need to export/import?
Whatever it is, are transportable tablespaces an option? I've found these are a lot better to transfer tablespaces across systems than any other method: you basically save the metadata using export/import and then copy the files across using whatever the OS provides for that purpose.

• Cheers Nuno Souto in sunny Sydney, Australia dbvision_at_iinet.net.au -- http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l

Received on Sat Jan 16 2010 - 12:05:34 CST