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

Thread: Data Pump error

  1. #1
    Join Date
    Nov 2000
    Posts
    224

    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

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



Click Here to Expand Forum to Full Width