Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

problem in expdp/impdp

Rizwan JooMar 25 2014 — edited Apr 1 2014

hi, i am trying to expdp/impdp but every time getting the same errors. OS win server 03 on ORACLE 10g.

errors:

C:\Documents and Settings\Administrator>impdp '/ as sysdba' directory='data_pump_dir' dumpfile='scott.dmp' logfile=scott.log'

Import: Release 10.2.0.3.0 - Production on Tuesday, 25 March, 2014 10:43:18

Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production

With the Partitioning, OLAP and Data Mining options

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_INTERNAL_LOGSTDBY" has errors

ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_INTERNAL_LOGSTDBY"

SQL> alter package DBMS_INTERNAL_LOGSTDBY compile body;

Warning: Package Body altered with compilation errors.

SQL> show error

Errors for PACKAGE BODY DBMS_INTERNAL_LOGSTDBY:

LINE/COL ERROR

-------- -----------------------------------------------------------------

2563/4   PL/SQL: SQL Statement ignored

2563/20  PL/SQL: ORA-00942: table or view does not exist

2625/3   PL/SQL: SQL Statement ignored

2625/19  PL/SQL: ORA-00942: table or view does not exist

2809/2   PL/SQL: SQL Statement ignored

2809/13  PL/SQL: ORA-00942: table or view does not exist

HELP ME OUT PLZ

This post has been answered by Emad Al-Mousa on Mar 25 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 29 2014
Added on Mar 25 2014
6 comments
3,622 views