- 论坛徽章:
- 0
|
下面是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. |
|