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
page revision: 2, last edited: 29 Apr 2009 15:00