IMP-00017: 由于 ORACLE 的 6550 错误,以下的语句失败
"BEGIN "
"sys.dbms_logrep_imp.instantiate_schema(schema_name=>'TEST', export_db_name"
"=>'ONLYTEST', inst_scn=>'15182380');"
"COMMIT; END;"
IMP-00003: 遇到 ORACLE 错误 6550
ORA-06550: 第 2 行, 第 1 列:
PLS-00201: 必须说明标识符 'SYS.DBMS_LOGREP_IMP'
ORA-06550: 第 2 行, 第 1 列:
PL/SQL: Statement ignored
IMP-00017: 由于 ORACLE 的 922 错误,以下的语句失败
以下略....................................
如果解决了再加100分都不成问题,请大家帮忙
---------------------------------------------------------------
Run the corresponding packages in the destination database 'SYS.DBMS_LOGREP_IMP'
Change(s) ~~~~~~~~~ The source database has been upgraded to Oracle9i Release 2 (9.2.0.x). An export with a lower release export utility is run against this database in order to import the data of the export dump file into a lower release database (e.g.: 9.0.1.4 or 8.1.7.4).
Cause ~~~~~~~ The SYS.DBMS_LOGREP_% packages have been introduced in Oracle9i Release 2. The packages SYS.DBMS_LOGREP_EXP and SYS.DBMS_LOGREP_IMP do not exist in the data dictionary of lower releases (9iR1 and 8i). If you want to export data from Oracle9i and import it into Oracle8i, you have to export the data with the Export utility of the lowest database version involved. The errors during import occur when importing an export dump file that was created from an Oracle9i Release 2 (9.2.0.x) database, by using this lower release export utility (e.g. 9.0.1.4 or 8.1.7.4). Note that the errors do not occur when the export is done in table-level mode. E.g.: % exp system/manager tables=scott.tab1,scott.tab2
Fix ~~~ Ignore these errors during import, as they have no impact on the import when importing in Oracle9iR1 (9.0.1.x) and Oracle8i (8.1.7.x and 8.1.6.x).
---------------------------------------------------------------
导入数据库我是经常做的,而且有的问题都能解决,
你可否把你EXP的过程(数据库版本,ORACLE的字符级),IMP的版本,字符级
详细的说名一下,相信可以帮你解决问题。
---------------------------------------------------------------
多谢两位,我确实是从9.2.0导入到9.0.1
问题和hdkkk兄贴的相同
最后换了个9.2.0的库导入基本成功