免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 4318 | 回复: 0
打印 上一主题 下一主题

关于imp中的ORACLE error 6550问题!!急!!! [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2004-10-29 15:09 |只看该作者 |倒序浏览
下面是exp及imp数据文件的屏幕提示:

说明:
exp指令及imp指令均使用了Solaris操作系统下的Oracle 9.0.1.1.0所带指令。
exp数据源服务器:Windows 2000 Server (sp4)下安装的Oracle 9.2.0.1数据库

在imp数据时,Oracle报告“IMP-00003: ORACLE error 6550 encountered”错误

我在网上查找资料,据某些论坛上的说法为由于Oracle 9i从高版本向底版本导入数据所产生的错误,可以忽略。由于数据用于关键的应用,因此希望向各位高手证实这样的说法是否正确。

$ exp system/*****@othersmsdb file=/backup/move20041018.dmp owner=wh_sms,wh_cas,wh_center

Export: Release 9.0.1.1.0 - Production on Thu Oct 28 16:30:21 2004

(c) Copyright 2001 Oracle Corporation.  All rights reserved.


Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user WH_SMS
. exporting foreign function library names for user WH_CAS
exported
. . exporting table               SYS_VOCATION_TAB         13 rows  exported

.....................................................

. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully without warnings.

$ imp system/******@smsdb file=/backup/move20041028.dmp fromuser=wh_sms,wh_cas,wh_center touser=wh_sms,wh_cas,wh_center

Import: Release 9.0.1.1.0 - Production on Thu Oct 28 16:45:04 2004

(c) Copyright 2001 Oracle Corporation.  All rights reserved.


Connected to: Oracle9i Enterprise Edition Release 9.0.1.1.0 - 64bit Production
With the Partitioning option
JServer Release 9.0.1.1.0 - Production

Export file created by EXPORT:V09.00.01 via conventional path
import done in ZHS16GBK character set and AL16UTF16 NCHAR character set
. importing WH_SMS's objects into WH_SMS
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN  "
"sys.dbms_logrep_imp.instantiate_schema(schema_name=>;'WH_SMS', export_db_nam"
"e=>;'SMSDB.US.ORACLE.COM', inst_scn=>;'1729672');"
"COMMIT; END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 2, column 1:
PLS-00201: identifier 'SYS.DBMS_LOGREP_IMP' must be declared
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored
. importing WH_CAS's objects into WH_CAS
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN  "
"sys.dbms_logrep_imp.instantiate_schema(schema_name=>;'WH_CAS', export_db_nam"
"e=>;'SMSDB.US.ORACLE.COM', inst_scn=>;'1729672');"
"COMMIT; END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 2, column 1:
PLS-00201: identifier 'SYS.DBMS_LOGREP_IMP' must be declared
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored
. importing WH_CENTER's objects into WH_CENTER
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN  "
"sys.dbms_logrep_imp.instantiate_schema(schema_name=>;'WH_CENTER', export_db_"
"name=>;'SMSDB.US.ORACLE.COM', inst_scn=>;'1729672');"
"COMMIT; END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 2, column 1:
PLS-00201: identifier 'SYS.DBMS_LOGREP_IMP' must be declared
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored
. importing WH_SMS's objects into WH_SMS
. . importing table "AMS_ACCOUNTING_LABOR_PRICE_TAB"          0 rows imported
. . importing table "AMS_AGENT_ACCOUNTING_OUT_TAB"          0 rows imported
. . importing table     "AMS_AGENT_ACCOUNTING_TAB"          0 rows imported
. . importing table         "AMS_AGENT_LEDGER_TAB"          0 rows imported
. . importing table "AMS_AGENT_SETTLEMENT_BILL_TAB"          0 rows imported
. . importing table        "AMS_BASE_STRATEGY_TAB"         49 rows imported
. . importing table    "AMS_CON_SUBCHARGE_REL_TAB"        204 rows imported
. . importing table        "AMS_INVOICE_GROUP_TAB"          0 rows imported
. . importing table              "AMS_INVOICE_TAB"          0 rows imported
...........................................................................
. importing WH_SMS's objects into WH_SMS
. importing WH_CENTER's objects into WH_CENTER
. importing WH_SMS's objects into WH_SMS
About to enable constraints...
. importing WH_CENTER's objects into WH_CENTER
. importing WH_SMS's objects into WH_SMS
. importing WH_CENTER's objects into WH_CENTER
Import terminated successfully with warnings.
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP