Transportable Tablespaces (TTS) Migration - without RMAN

Migration of the Database and the usage of  TTS

If the source and Exadata target are on the same platform/endian and you are moving only tablespaces, you can use **TTS without RMAN**.

Step 1: Check TTS restrictions and self-containment

exec dbms_tts.transport_set_check('TS1,TS2', true);

select * from transport_set_violations;

Validates that the selected tablespaces are self-contained and eligible for transport without dependent objects outside the transport set.

Step 2: Put the tablespaces in READ ONLY mode

alter tablespace TS1 read only;

alter tablespace TS2 read only;

Freezes changes to the tablespaces to ensure consistent datafiles during transport.

Step 3: Export metadata using Data Pump

expdp '/ as sysdba' dumpfile=ORCL_Metadata.dmp \

logfile=ORCL_Metadata.log directory=C02_ESB_Metadata \

transport_tablespaces=AM_TS,SI_TS,PA_TS,VA_TS

Exports only the metadata definitions (tables, indexes, privileges, etc.) required to reconstruct the transported tablespaces on the target database.

Step 4: Copy datafiles and dump file to Exadata (From Source to Target)

Transfers the physical tablespace datafiles and exported metadata from the source server to the Exadata target server.

Step 5: Import metadata and plug in the datafiles

impdp system/password directory=DP_DIR \

dumpfile=tts.dmp logfile=tts_imp.log \

transport_datafiles='/path/ts1.dbf','/path/ts2.dbf'

Registers the transported datafiles in the target database and imports the corresponding metadata.

Step 6: Set tablespaces back to READ WRITE mode

alter tablespace TS1 read write;

alter tablespace TS2 read write;

Opens the transported tablespaces for normal application access and DML operations after successful migration.

TTS Summary :-

Transportable Tablespaces (TTS) is a migration method that moves Oracle tablespaces by transporting their datafiles and metadata, avoiding a full database export/import and significantly reducing migration time for large databases when source and target platforms have the same endian format.