Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

IMP-00020: long column too large for column buffer size (number)

1 Answers  


ORA-16720: no available LOG_ARCHIVE_DEST_n parameters to use

1 Answers  


ORA-07847: sllfop: $CONNECT failure

1 Answers  


ORA-22915: cannot ALTER a nested table's storage table to ADD/MODIFY columns

1 Answers  


NID-00306: Datafile string - no revert needed

1 Answers  






ORA-01539: tablespace 'string' is not online

1 Answers  


ORA-32601: value for retention cannot be provided

1 Answers  


NCR-01006: NCRS: Data buffer overflow.

1 Answers  


ORA-12034: materialized view log on "string"."string" younger than last refresh

2 Answers  


ORA-23355: object string.string does not exist or is invalid at master site

1 Answers  


ORA-08310: sllfop: Bad value for recsize

1 Answers  


NNL-00905: NOT AUTHORITY responses sent: number

1 Answers  






Categories