Re: ORACLE IMPORT PROBLEM

From: Lewis C <lewisc_at_excite.com>
Date: Mon, 06 Jun 2005 01:28:34 GMT
Message-ID: <di97a1hkjkih3oto4erk65c6qjemv4q3vt@4ax.com>

On 5 Jun 2005 04:58:43 -0700, "Obi Wan Shinobi" <Order66_at_hotmail.co.uk> 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.

A couple of quick guesses.

If you imp'ing the same user you exp'ed, do they have the same permissions?

Are the DBs the same version?

Other than that, post a lot more info. DB versions, EXP parameters, etc.

LewisC

Lewis R Cunningham

Author, ItToolBox Blog: An Expert's Guide to Oracle http://blogs.ittoolbox.com/oracle/guide/

Topic Editor, Suite101.com: Oracle Database http://www.suite101.com/welcome.cfm/oracle

Received on Sun Jun 05 2005 - 20:28:34 CDT