-
Book Overview & Buying
-
Table Of Contents
Oracle Database 12c Backup and Recovery Survival Guide
You can use Data Pump to transport tablespaces between databases, or even transport a complete database. This method prior to the introduction of Oracle 12c was the faster way to migrate data; now in Oracle 12c, the faster way to migrate a complete Oracle Database is using Full Transportable Export/Import as detailed in Chapter 3, What is new in 12c.
The following list of steps summarizes the process of transporting a tablespace from one database to another:
Pick a self-contained set of tablespaces.
As we have seen in Chapter 9, Understanding Data Pump, we can use the TRANSPORT_SET CHECK procedure to verify if a tablespace is self-contained. For this scenario we will transport the tablespace EXAMPLE from a database 11.2.0.3 that contains the schema TESTx to our pluggable database pdborcl in 12.1.
Let's start checking if this tablespace is self-contained.
Remember that you should have EXECUTE_CATALOG_ROLE granted to be able to execute the TRANSPORT_SET_CHECK procedure...
Change the font size
Change margin width
Change background colour