ORA-24057: cannot define subscriber with rule for queue string



ORA-24057: cannot define subscriber with rule for queue string..

Answer / guest

Cause: An ADD_SUBSCRIBER or ALTER_SUBSCRIBER procedure with
a rule was issued on a queue for which rule based
subscribers are not supported. Rule based subscribers
currently are supported only for NORMAL (persistent)
multi-consumer queues created using an Oracle release 8.1.0
or higher compatible queue table.

Action: Create a NORMAL multi-consumer queue in an Oracle
release 8.1.0 or higher compatible queue table, and retry
the call. Or, if the queue is a normal (persistent)
multi-consumer queue, convert the queue table to Oracle
8.1.0 or higher compatibility and retry.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-01080: error in shutting down ORACLE

1 Answers  


ORA-31531: could not find column string in CDC subscriber view string.string

1 Answers  


QSM-02116: mupltiple master sites

1 Answers  


ORA-00750: database has been previously mounted and dismounted

2 Answers  


ORA-02320: failure in creating storage table for nested table column string

1 Answers  






ORA-30355: materialized view container does not exist

1 Answers  


IMG-00853: internal image structure free failed

1 Answers  


PCC-00093: Invalid or obsolete option, ignored

1 Answers  


ORA-16195: DG_CONFIG requires DB_UNIQUE_NAME be explicitly defined

1 Answers  


QSM-01063: query has a dictionary table or view

1 Answers  


NNL-00930: Requests refused, unknown data type: number

1 Answers  


ORA-23423: job number string is not positive

1 Answers  


Categories