不同SID数据库导入导出语句
exp user/password@$ORACLE_SID file=EXP.dmp log=EXP.log
imp user/password@$ORACLE_SID file=EXP.dmp ignore=y log=IMP.log FULL=Y
===========
结果在imp的时候报错。源SID是inomc,目的sid是ora11g
日志如下：
Warning: the objects were exported by SYSTEM, not by you
import done in UTF8 character set and AL16UTF16 NCHAR character set
import server uses AL32UTF8 character set (possible charset conversion)
. importing SYSTEM's objects into CTXSYS
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN SYS.DBMS_DEFER_IMPORT_INTERNAL.QUEUE_IMPORT_CHECK('INOMC','x86_64/L"
"inux 2.4.xx'); END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 1, column 9:
PLS-00201: identifier 'SYS.DBMS_DEFER_IMPORT_INTERNAL' must be declared
ORA-06550: line 1, column 9:
PL/SQL: Statement ignored
. . importing table "DEF$_AQCALL" 0 rows imported
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN SYS.DBMS_DEFER_IMPORT_INTERNAL.QUEUE_IMPORT_CHECK('INOMC','x86_64/L"
"inux 2.4.xx'); END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 1, column 9:
PLS-00201: identifier 'SYS.DBMS_DEFER_IMPORT_INTERNAL' must be declared
ORA-06550: line 1, column 9:
PL/SQL: Statement ignored
[解决办法]
你导入导出的用户不是同一个么？
[解决办法]
跟SID没有关系。
