-
Book Overview & Buying
-
Table Of Contents
-
Feedback & Rating

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