-
Data Pump error
I am getting following error when trying to run datapump export for full database. I get the same error even when I try to run export for single user only. I am logging as SYSTEM user.
expdp system/oracle directory=data_pump_dir dumpfile=bsgFull.dmp full=y
Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORA-31626: job does not exist
ORA-31637: cannot create job SYS_EXPORT_FULL_01 for user SYSTEM
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT_INT", line 601
ORA-39080: failed to create queues "" and "" for Data Pump job
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPC$QUE_INT", line 1550
ORA-01403: no data found
-
Hi Sharma,
Can you check if all your SYS objects are VALID and if not run $ORACLE_HOME/rdbms/admin/utlrp.sql.
I suspect some datapump related views may not have got created successfully.
Thanks
Nagendra M
"DBA by Choice"
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|