ORACLE IMPORT PROBLEM

From: Obi Wan Shinobi <Order66_at_hotmail.co.uk>
Date: 5 Jun 2005 04:58:43 -0700
Message-ID: <1117972723.493531.72290@g47g2000cwa.googlegroups.com>

Hi,

I'm new to Oracle so I thought someone here might be able to help me. I'm trying to do a schema import using imp and i get the following in the import log file (below). It looks like the like PLS-00201: identifier 'SYS.DBMS_LOGREP_IMP' must be declared is where the error cascade begins. How do I declare 'SYS.DBMS_LOGREP_IMP' ?

import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
. importing EXMETA's objects into EXMETA IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN "
"sys.dbms_logrep_imp.instantiate_schema(schema_name=>'EXMETA',
export_db_n"
"ame=>'EXIMTD.SYS_NAME.COM', inst_scn=>'66741801');"
"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
IMP-00017: following statement failed with ORACLE error 922:
"CREATE TABLE "ECD_ACCRULE_SET" ("RULE_ID" VARCHAR2(12) NOT NULL
ENABL" etc. etc.

Any help would be appreciated.

Many Thanks. Received on Sun Jun 05 2005 - 06:58:43 CDT