Re: Data Pump error

From: Ron Schuster <ronschuster123_at_yahoo.com>
Date: Mon, 02 Oct 2006 09:37:38 -0400
Message-ID: <12i25hdlrf5kadc_at_corp.supernews.com>

[Quoted] Vladimir M. Zakharychev wrote:

> 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"

> 
[Quoted] > This one is particularly alerting: ORA-04063: package body
> "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
> 

If I just installed Oracle Express, what is the password for SYSDBA? Received on Mon Oct 02 2006 - 15:37:38 CEST