We blogged about Full Transportable Export/Import a while back. It is - no doubt - one of the coolest features in Oracle Database 12c. And it is part of our Hands-On Lab exercise (Hands On Lab - Upgrade, Migrate, Consolidate to Oracle Database 12c) as well.
It utilizes the technique of Transportable Tablesspaces - cross-platform, cross- Endianness, cross-version - but lets Oracle Data Pump do all the "dirty" work of rebuilding everything kept in your SYSTEM and SYSAUX tablespace including views, synonyms, public objects, grants, sequences etc etc etc.
You can even combine it with RMAN Incremental Backups - of course cross-platform and cross-Endianness as well - in order to decrease the downtime for large databases.
Please find our presentation about the combination of these feature here in the Slides Download Center to the right:
In addition: You can use this Oracle Database 12c feature with your source database Oracle 18.104.22.168 or 22.214.171.124. Just the destination database you are upgrading or migrating to must be at least an Oracle 126.96.36.199 database (or newer of course).
Roy recorded a 20 minute video demonstrating how to:
And of course the feature works also without migrating into a Container database environment - and without migrating to the Oracle DBaaS Cloud.
If you need to migrate a database from Oracle 188.8.131.52 or newer to Oracle Database 12c Full Transportable Export/Import can become your best friend.
We recently worked with a customer who noticed that they were not able to use transportable tablespaces to connect the same tablespace data...
Now that I am back from OpenWorld, I will hijack the Upgrade blog while Mike is traveling. :-) Thank you to everybody who came to our...