O'Reilly logo

Oracle Database 12c Backup and Recovery Survival Guide by Aman Sharma, Francisco Munoz Alvarez

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required