OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » database import

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

database import [message #58169]

Tue, 05 August 2003 09:06

raman
Messages: 66
Registered: February 2000

Member

Hi folks,

Can anyone please help with the following...

When importing any dmp file I am getting the following errors...

IMP-00017: following statement failed with ORACLE error 4068:
"BEGIN SYS.DBMS_REPCAT_MIG.PRE_IMPORT; END;"
IMP-00003: ORACLE error 4068 encountered
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.DBMS_REPCAT_MIG_INTERNAL" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_REPCAT_MIG", line 95
ORA-06512: at line 1
IMP-00000: Import terminated unsuccessfully

Any ideas greatly appreciated!

Thanks.

Report message to a moderator

Re: database import [message #58171 is a reply to message #58169]

Tue, 05 August 2003 09:14

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

are source and target databases of same version?

if so, run these scripts logged in as sys or internal
catrepr.sql,catrep.sql,utlrp.sql   
and try again.

Report message to a moderator

Re: database import [message #58172 is a reply to message #58171]

Tue, 05 August 2003 09:20

raman
Messages: 66
Registered: February 2000

Member

THank you for the tip!

Can you please explain what the scripts that you have mentioned actually do?

Thanks again.

Report message to a moderator

Re: database import [message #58174 is a reply to message #58172]

Tue, 05 August 2003 09:22

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

catrepr.sql - removes replication objects
catrep.sql - creates them
utlrp.sql - recompiles the invalid modules

Report message to a moderator

Re: database import [message #61418 is a reply to message #58171]

Thu, 22 April 2004 05:53

ehoehoeho
Messages: 3
Registered: April 2004

Junior Member

Hello!

But if source and target databases aren't of same version (export from 8.1.6 and import to 9.2) ??

thx

Report message to a moderator

Previous Topic:	Oracle Server RAM upgrade
Next Topic:	DES3ENCRYPT in Oracle817

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 12:25:20 CDT 2024