Re: Export Import Large Database - 9i
- From: Nuno Souto <dbvision@xxxxxxxxxxxx>
- Date: Sat, 16 Jan 2010 21:29:07 +1100
Errr.....no.
tranportable tablespaces were introduced in 8i.
In 9i the feature was widely available and relatively
error free, you should be able to use it.
Or at least, so does sayeth Part No. A96520-01,page 12-3,
the Oracle Data Warehousing Guide, release 2(9.2).
Look it up, whenever "unbreakable Oracle" decides
to return the tahiti manuals to the www...
--
Cheers
Nuno Souto
in sunny Sydney, Australia
dbvision@xxxxxxxxxxxx
Oracle Dba Wannabe wrote,on my timestamp of 16/01/2010 9:07 PM:
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
