Re: Data Pump error

Ron Schuster wrote:
> I'm getting the following error trying to do a data pump export in 10g
> Express. I'm basically just trying to follow the example in the help.
>
> C:\Documents and Settings\eheard>expdp SYSTEM/dbo SCHEMAS=hr
> DIRECTORY=dmpdir DUMPFILE=schema.dmp LOGFILE=expschema.log
>
> Export: Release 10.2.0.1.0 - Production on Thursday, 28 September, 2006
> 11:27:58
>
> Copyright (c) 2003, 2005, Oracle. All rights reserved.
>
> Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 -
> Production
> ORA-31626: job does not exist
> ORA-31637: cannot create job SYS_EXPORT_SCHEMA_01 for user SYSTEM
> 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_20060928112759" and "" for
> Data Pump 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_SYS" has errors
> ORA-06508: PL/SQL: could not find program unit being called:
> "SYS.DBMS_AQADM_SYS"
This one is particularly alerting: ORA-04063: package body [Quoted] "SYS.DBMS_AQADM_SYS" has errors. Looks like something's not right with your database. Try connecting AS SYSDBA and re-running _at_?/rdbms/admin/catqueue.sql to redo AQ initialization. If you will hit any errors during this script execution and won't be able to fix them yourself, post them here. If there will be no errors, try your export again and see if the original problem persists.

Hth,

    Vladimir M. Zakharychev
    N-Networks, makers of Dynamic PSP(tm)     http://www.dynamicpsp.com Received on Mon Oct 02 2006 - 08:36:02 CEST