TTS

1

execute dbms_tts.transport_set_check('example',true);
SELECT * FROM TRANSPORT_SET_VIOLATIONS;

2

expdp system/oracle dumpfile=expdat.dmp directory=data_pump_dir transport_tablespaces=example

3

cp ./oradata/OMR/example01.dbf ./oradata/PROD/

4

impdp system/oracle dumpfile=expdat.dmp directory=data_pump_dir 
transport_datafiles=/u01/app/oracle/oradata/PROD/example01.dbf
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License