Data Pump error
From: Ron Schuster <ronschuster123_at_yahoo.com>
Date: Thu, 28 Sep 2006 13:13:10 -0400
Message-ID: <12ho0l528gmlhf3_at_corp.supernews.com>
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.
Date: Thu, 28 Sep 2006 13:13:10 -0400
Message-ID: <12ho0l528gmlhf3_at_corp.supernews.com>
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 "" forData 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" Received on Thu Sep 28 2006 - 19:13:10 CEST