Home » RDBMS Server » Server Utilities » errors while impdp (10.2.0.2)
errors while impdp [message #359921] Tue, 18 November 2008 17:51 Go to next message
varunvir
Messages: 363
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
Re: errors while impdp [message #359925 is a reply to message #359921] Tue, 18 November 2008 18:47 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


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

Babu
Re: errors while impdp [message #359929 is a reply to message #359925] Tue, 18 November 2008 19:06 Go to previous messageGo to next message
varunvir
Messages: 363
Registered: November 2007
Senior Member
both are 10.2.0.2
Regards,
Varun Punj,
Re: errors while impdp [message #359930 is a reply to message #359929] Tue, 18 November 2008 19:20 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

please confim me.

show parameter compatible


Babu
Re: errors while impdp [message #360089 is a reply to message #359930] Wed, 19 November 2008 10:02 Go to previous messageGo to next message
varunvir
Messages: 363
Registered: November 2007
Senior Member
Babu,
I resolved the error by running cataproc.sql and utlrp.sql.
Regards,
Varun Punj,
Re: errors while impdp [message #360112 is a reply to message #360089] Wed, 19 November 2008 11:51 Go to previous message
babuknb
Messages: 1734
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
Previous Topic: Problem while Importing...
Next Topic: ctl file to remove duplicates
Goto Forum:
  


Current Time: Thu Dec 08 08:19:46 CST 2016

Total time taken to generate the page: 0.12211 seconds