DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Data Pump error

  1. #1
    Join Date
    Nov 2000

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

  2. #2
    Join Date
    Sep 2007
    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.

    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

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.