今天做了下clone库和表空间传输的实验。有几个注意事项:
clone>host exp \'sys/clone as sysdba\' transport_tablespace=y tablespaces=tbs01 file=/tmp/tbs01_clone.dmp log=/tmp/tbs01_exp_clone.log
Export: Release 9.2.0.4.0 - Production on Sun Feb 27 00:11:09 2011
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
Export done in US7ASCII character set and UTF8 NCHAR character set
server uses ZHS16GBK character set (possible charset conversion)
Note: table data (rows) will not be exported
About to export transportable tablespace metadata...
EXP-00008: ORACLE error 29341 encountered
ORA-29341: The transportable set is not self-contained
ORA-06512: at "SYS.DBMS_PLUGTS", line 1143
ORA-06512: at line 1
EXP-00000: Export terminated unsuccessfully
clone>host oerr oar 29341
oerr: Unknown facility 'oar'
clone>host oerr ora 29341
29341, 00000, "The transportable set is not self-contained"
// *Cause: The set of objects in the set of tablespaces selected are
// not self-contained.
// *Action: Consider using different export options, or removing some
// of the pointers that caused the violation, or selecting a
// different set of tablespaces.
-----这里的自包含self-contained怎么理解?看了别人的讲解,还是没有明白。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/713360/viewspace-688013/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/713360/viewspace-688013/