Solved

Data Pump utility

Posted on 2006-07-20
2
1,576 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

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

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
Via a live example, show how to take different types of Oracle backups using RMAN.

695 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