OraFAQ Forum: Server Utilities » errors while impdp

Home » RDBMS Server » Server Utilities » errors while impdp (10.2.0.2)

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

errors while impdp [message #359921]

Tue, 18 November 2008 17:51

varunvir
Messages: 389
Registered: November 2007

Senior Member

HiExperts,
I am getting following errors when I am runiing impdp.sh.

ORA-31626: job does not exist
ORA-04063: package body "SYS.DBMS_INTERNAL_LOGSTDBY" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_INTERNAL_LOGSTDBY"
ORA-06512: at "SYS.KUPV$FT", line 834
ORA-04063: package body "SYS.DBMS_LOGREP_UTIL" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_LOGREP_UTIL"

Can you please tell me what can I do to avoid those.
Regards,
Varun Punj

Report message to a moderator

Re: errors while impdp [message #359925 is a reply to message #359921]

Tue, 18 November 2008 18:47

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

1/ What about your target database version ??
2/ What about your compatible parameter

Babu

Report message to a moderator

Re: errors while impdp [message #359929 is a reply to message #359925]

Tue, 18 November 2008 19:06

varunvir
Messages: 389
Registered: November 2007

Senior Member

both are 10.2.0.2
Regards,
Varun Punj,

Report message to a moderator

Re: errors while impdp [message #359930 is a reply to message #359929]

Tue, 18 November 2008 19:20

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

please confim me.

show parameter compatible

Babu

Report message to a moderator

Re: errors while impdp [message #360089 is a reply to message #359930]

Wed, 19 November 2008 10:02

varunvir
Messages: 389
Registered: November 2007

Senior Member

Babu,
I resolved the error by running cataproc.sql and utlrp.sql.
Regards,
Varun Punj,

Report message to a moderator

Re: errors while impdp [message #360112 is a reply to message #360089]

Wed, 19 November 2008 11:51

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Hello,

Thanks for your update.

Actually this error only occur in 9i version or If you upgrade 9i to 10g.

That's the reason I'm asking your database version.

Ref: For more details pls check metalink.

Again Thanks a lot for your information.

Babu

Report message to a moderator

Previous Topic:	Problem while Importing...
Next Topic:	ctl file to remove duplicates

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 24 11:11:45 CST 2024