Obi Wan Shinobi wrote:
> 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.
>
You provide precious little info:
- what version(s) of Oracle?
- what errors bother you (the IMP-00017/ORA-06650, or the
IMP-00003/ORA-06650, or all)
- how was the export made (command line options, please)
- how do you attempt to import (ditto)
--
Regards,
Frank van Bortel
Received on Sun Jun 05 2005 - 07:40:23 CDT
