Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1634
  • Last Modified:

Data Pump utility

I am trying to invoke the Data Pump utility.

I have created a server directory object as a first step:

CONN sys/password@DB AS SYSDBA
GRANT CREATE ANY DIRECTORY TO MTR;

CREATE OR REPLACE DIRECTORY MTRDataPump AS 'C:\oracle\OraData\MTRDataPump';

GRANT READ, WRITE ON DIRECTORY MTRDataPump TO MTR;

When I try to invoke ExpDp utility, using parameters posted further below, I am
receiving the error:

ORA-31626: job does not exist
ORA-31637: cannot create job SYS_EXPORT_TABLE_01 for user MTR
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT_INT", line 600
ORA-39080: failed to create queues "KUPC$C_1_20060720135641" and "" for Data
Pum
p job
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPC$QUE_INT", line 1555
ORA-04063: package body "SYS.DBMS_AQADM" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_AQADM"

The arguments I used to run the utility are:

expdp mtr/password@tdb PARFILE=MyPar.PAR

MyPar:
DIRECTORY=MTRDataPump
CONTENT=DATA_ONLY
DUMPFILE=MTR.dmp
PARALLEL=2
LOGFILE=MTR.log
TABLES=MyTable


Please advice,
0
marper
Asked:
marper
2 Solutions
 
knutsoneCommented:
Maybe try to recompile the dbms_aqadm package?

--As SYS try this:
alter package DBMS_AQADM compile

The error message seems to say that the package body is invalid

"ORA-04063: package body "SYS.DBMS_AQADM" has errors"

Cheers,
  Eric
0
 
sathyagiriCommented:
Try to recompile all your invalid objects by running the utlprp.sql under the rdbms/admin folder. Run this as sys user
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now