Transporting a tablespace

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:

1. Pick a self-contained set of tablespaces.

2. 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.

3. Let's start checking if this tablespace is self-contained.

   Note

   Remember that you should have EXECUTE_CATALOG_ROLE granted to be able to execute the TRANSPORT_SET_CHECK procedure...