exp user/password@$ORACLE_SID file=EXP.dmp log=EXP.logimp 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 youimport 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
===========结果在imp的时候报错。源SID是inomc,目的sid是ora11g日志如下:Warning: the objects were exported by SYSTEM, not by youimport 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
解决方案 »
- 关于oracle导入导出的问题。求解惑。
- 创建了oracle 函数,但是在 plsql的function中找不到,数据库中也没有这函数。
- 有关oracle max函数的疑惑,求解!
- linx as3下oracle监听无法启动
- 建表时如何给字段加默认值
- 局域网内,几个工作站用plsql同一个用户能登陆一个服务器吗?
- 怎么取查询出来的任意几行数据
- 请各位高手解答我的疑惑
- 可以得到所有表名?添加标识?
- testuser用户以normal身份登录后创建表 mytab,当用户testuser以sysdba 身份登录时却不能访问?但如果用如下语句(select * from testuser
- Oracle 数据库连接杂记
- plsql developer连接不上windows 7 下安装的oracle11g
这是个系统用户,由于新环境里面没装,想从原来的地方导个过来
"BEGIN SYS.DBMS_DEFER_IMPORT_INTERNAL.QUEUE_IMPORT_CHECK('INOMC','x86_64/L"
"inux 2.4.xx'); END;"