EXPDP data pump error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: EXPDP data pump error

Hybrid View

  1. #1
    Join Date
    Apr 2008
    Posts
    59

    EXPDP data pump error

    Hi Gurus,

    Could u please let me know the solution for this problem...

    when i export it showing this type of error.

    expdp dumpfile=full.dmp logfile=full.log full=y directory=dpump

    ORA-31626: job does not exist
    ORA-31637: cannot create job SYS_EXPORT_FULL_01 for user SYS
    ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
    ORA-06512: at "SYS.KUPV$FT_INT", line 663
    ORA-39080: failed to create queues "KUPC$C_1_20101008115016" and "" for Data Pum
    p job
    ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
    ORA-06512: at "SYS.KUPC$QUE_INT", line 1665
    ORA-24203: operation failed, queue table SYS.KUPC$DATAPUMP_QUETAB has errors

  2. #2
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    Is this database recently upgraded or any patches applied ?

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  3. #3
    Join Date
    Apr 2008
    Posts
    59
    no it is a newly created test database... do u hav any suggestions??

  4. #4
    Join Date
    Jan 2007
    Location
    Dayton, OH
    Posts
    15
    You should always check metalink or google before asking for help. A 3 sec search on metalink gave me this:

    Symptoms
    You are trying to use both expdp and impdp and keep getting the following errors in the logfiles:


    Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options
    ORA-31626: job does not exist
    ORA-31637: cannot create job SYS_EXPORT_SCHEMA_01 for user EFG
    ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
    ORA-06512: at "SYS.KUPV$FT_INT", line 663
    ORA-39080: failed to create queues "KUPC$C_1_20080717121049" and "KUPC$S_1_20080717121049" for Data Pump job
    ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
    ORA-06512: at "SYS.KUPC$QUE_INT", line 1665

    Cause
    The streams_pool_size is too small.

    Solution
    1. Make sure the streams_pool_size is 100MB and retry the expdp and impdp.

    -This may not be your problem, but its an excellent place to start.

    Jim

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