Oracle 9i to 8i problem

From: MC <morgonc_at_yahoo.com>
Date: 12 Nov 2002 01:27:41 -0800
Message-ID: <1c458600.0211120127.7fb3dc2a@posting.google.com>

Dear All.

I exported objects under a schema in Oracle 9i using v8.1.7 export and import them into another database running Oracle 8.1.7. When I imported the file, following error exists:

Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
JServer Release 8.1.7.0.0 - Production

Export file created by EXPORT:V08.01.07 via conventional path

Warning: the objects were exported by MMSBAT, not by you

import done in US7ASCII character set and US7ASCII NCHAR character set export server uses UTF8 NCHAR character set (possible ncharset conversion)
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN "
"sys.dbms_logrep_imp.instantiate_schema(schema_name=>'PMAS01',
export_db_nam"
"e=>'MMSP.WORLD', inst_scn=>'327056909');"
"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

Anyone know why and how to fix it?

Thanks in advance
MC. Received on Tue Nov 12 2002 - 03:27:41 CST