Understanding Transportable Tablespace Data Pump

Transportable Tablespace Data Pump is generally much faster than conventional Data Pump management. Data files forming the tablespace are simply copied to the new repository. Then, the Data Pump process transfers the metadata of the objects covered by the tablespace to the new database. The step-by-step sequence is as follows:

1. Prepare the database for the Transportable Tablespace Data Pump on the on-premise. Set the tablespaces to the READ ONLY mode:

   ALTER TABLESPACE <tablespace_name> READ ONLY;

2. Invoke Data Pump export (ExpDp) on the on-premises database.
3. Copy the tablespace data files to the destination securely.
4. Set the on-premise tablespaces to the READ WRITE mode.

   ALTER TABLESPACE <tablespace_name> READ WRITE;

5. Prepare the destination database to import.
6. Invoke Data Pump import (ExpDp) on the destination database.
7. Set the destination database tablespaces to the READ WRITE mode.
8. Verify...