-
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,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
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
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
|