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 own the segments in the transport tablespace(ts_1).
5, imp '/ as sysdba ' file=ts1.dmp tablespaces=ts_1 transport_tablespace=y datafiles='e:ts_1.dmp' tts_owners=test
-- If you want to import segments to a new user in the destination , do as the following .
-- Assume you want to import segments from user test to scott.
imp '/ as sysdba ' file=ts1.dmp tablespaces=ts_1 transport_tablespace=y datafiles='e:ts_1.dmp' tts_owners=test
fromuser=test touser=scott.
-- convert byte-order in cross-platform transport tablespace.
-- do convert in source system .
http://tech.ccidnet.com/art/1105/20070307/1031109_2.html
http://blog.csdn.net/wangdeng1314/archive/2010/05/20/5612552.aspx
[@more@]来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/350519/viewspace-1042058/ ，如需转载，请注明出处，否则将追究法律责任。
最新文章
- aix, linux 解决特殊符号文件名:
- 在AIX,LINUX系统中访问含特殊符号的文件
- SSH Host key verification failed
- 让一个普通用户看到另一个用户的包体
- dbms_scheduler package body INVALID 解决方案
- db_recovery_file_dest_size, v$flashback_database_logfile,v$restore_point引发的血案.
- impdp 遇到 ORA-07445 错误。重新EXPDP，IMPDP解决了。
- drop user 死锁（物化视图，JOB）
- expdp, impdp ORA-39213 Metadata processing not available
- aix login shell permission error trouble shooting.
