Re: Export Import Large Database - 9i
- From: Oracle Dba Wannabe <oracledbawannabe@xxxxxxxxx>
- To: dbvision@xxxxxxxxxxxx
- Date: Sat, 16 Jan 2010 02:07:54 -0800 (PST)
I should have mentioned this is cross platform - xtts came in 10gR1
unfortunately.
Thanks
________________________________
From: Nuno Souto <dbvision@xxxxxxxxxxxx>
Cc: Oracle-L@xxxxxxxxxxxxx
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@xxxxxxxxxxxx
--
//www.freelists.org/webpage/oracle-l
Other related posts:
