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

Get Oracle Database 12c Backup and Recovery Survival Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial