HOW TO RECTIFY THIS ERROR IN DATA PUMP

[pavani m]

$ expdp
username:s1
password:s1
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
ORA-31626: job does not exist
ORA-31637: cannot create job SYS_EXPORT_SCHEMA_01 for user S1
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT_INT", line 600
ORA-39080: failed to create queues "KUPC$C_1_20080119113347" and "KUPC$S_1_20080119113347" for Data Pump job
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPC$QUE_INT", line 1555
ORA-00832: no streams pool created and cannot automatically create one

I RE INSTALL ALL THE PACKAGE I.E
@$ORACLE_HOME/rdbms/admin/catqueue.sql

SQL> show errors package body sys.dbms_aqadm_sys
No errors.
SQL> show errors package body sys.dbms_sys_error
No errors.
SQL> show errors package body SYS.KUPV$FT_INT
No errors.
SQL> show errors package body SYS.KUPC$QUE_INT
No errors.
SQL> show errors package body SYS_EXPORT_SCHEMA_01
No errors.
 
you have any idea about this error ,plz reply me soon

[fitzj...@cox.net]

I have plenty of ideas about this error, and so does the error message
list you posted. The answer is provided to you in that list:

ORA-00832: no streams pool created and cannot automatically create
one

Solution:

* allocate a streams pool by setting streams_pool_size to a non-zero
value and restart the database

WHY you reinstalled the queue catalog is a mystery to me. Nothing in
the error message list stated that any package was invalid.


David Fitzjarrell

[Anumula Raja , The ORACLE: UNBREAKABLE]

Just allocate

 

streams_pool parameter in the PFILE

 

and restart the expdp.

 

Hope this helps

 

[fitzj...@cox.net]

On Jan 19, 10:49 am, "Anumula Raja , The ORACLE: UNBREAKABLE"
<rajredd...@gmail.com> wrote:
> Just allocate
>
> *streams_pool parameter in the PFILE*

>
> and restart the expdp.
>
> Hope this helps
>

> --
> Cheers,
>
> Rajasekhar Reddy.A- Hide quoted text -
>
> - Show quoted text -

Your advice is, well, lacking. Setting or changing a parameter value
in the pfile requires a database restart, which you didn't mention.
Simply restarting expdp after setting a value in the pfile, without a
database restart, won't do anything. Dymanically setting this
parameter, however, WILL provide immediate benefit:

alter system set streams_pool_size = <some number here>;

Of course if the O/P is using a pfile then it also needs to be
adjusted to this new value so the change is not lost at the next
restart.


David Fitzjarrell