Oracle – Transportable Tablespaces

nnnnn

• Make the tablespace Read-Only = alter tablespace xxxx read only;
• Export it connecting as sys as sysdba = exp file=tt.dmp log=tt.log tablespaces=xxxx transportable_tablespaces=y
• Copy the .dmp file and the data_files to the destination
• Put the tablespace back in write mode = alter tablespace xxxx read write;
• In the destination offline and drop the tablespace if exists
• Import = imp file=tt.dmp log=tt.log tablespaces=test transportable_tablespace=y datafiles=(……., ……..)