Solved

Data Pump utility

Posted on 2006-07-20
2
1,540 Views
Last Modified: 2008-01-09
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
Comment
Question by:marper
2 Comments
 

Accepted Solution

by:
knutsone earned 65 total points
ID: 17150138
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
 
LVL 14

Assisted Solution

by:sathyagiri
sathyagiri earned 60 total points
ID: 17150570
Try to recompile all your invalid objects by running the utlprp.sql under the rdbms/admin folder. Run this as sys user
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Server Linked Server Using Oracle OPS$ Windows Authenticated Account 7 60
Pl/SQL Query 31 76
EXECUTE IMMEDIATE 5 53
use lov values 2 33
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now