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

Is this database recently upgraded or any patches applied ?

Thanks,

no it is a newly created test database... do u hav any suggestions??

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