以前每次用8i客户端导出9i数据库，再导入到8i库好像都没撒问题，这次开发组的兄弟说就是有问题了

IMP-00017: 由于 ORACLE 错误6550，以下的语句失败 “BEGIN ” “sys.dbms_logrep_imp.instantiate_schema(schema_name=>‘SDUSER’, export_db_nam” “e=>‘HLSD’, inst_scn=>‘4008049’);” “COMMIT; END;”
IMP-00003: ORACLE 错误6550出现 ORA-06550: 第 2 行, 第 1 列:
PLS-00201: 必须说明标识符 ‘SYS.DBMS_LOGREP_IMP’ ORA-06550: 第 2 行, 第 Cause
找了半天metalink解释如下
~~~~~~~
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).

说了半天就是9i的东西，8i不支持了。也不给个解决方法，ft



3 Comments to “9i imp到8i错误解决一例”

1. gytyl — February 28, 2006 @ 5:51 pm
   

   哈哈
   我发现问题了
   你这个是不是你在那个数据库上作了个rep的测试
   现在这个东西好像是rep的列
   8i当然没有了

2. flysers — March 1, 2006 @ 10:46 pm
   

   你还是很牛,这么难看的a.b.c.d都给你看懂了,我还要用工具!所以,顶你~~~~

3. bachelor — March 1, 2006 @ 10:52 pm
   

   晕，什么a.b.c.d吖
   这个不是我做rep的测试库,是sd系统的开发库

Write a comment

You need tologin.