ITPub博客

something need to keep in mind about transportable-tablespace migrate.1, execute dbms_tts.transport_set_check . -- check tablespace integrity.2, alter tablespace ts_1 read only -- set tablespace in read only mode.-- transport tablespace need sysdba privilege.3, exp '/ as sysdba ' file=ts1.dmp tablespaces=ts_1 transport_tablespace=y 4, host copy datafile .-- this is only assumed when datafile is an os file.-- import a transport tablespace need sysdba privilege.-- tts_owners specify the schema who