ORA-24057: cannot define subscriber with rule for queue string
- 1 Answers
- 2993 Views
- I also Faced
- E-Mail Answers
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 |
NNC-00401: program interface initialization failed
ORA-00322: log string of thread string is not current copy
ORA-36202: (XSAGOP01) 'number' is not a valid aggregation operator.
QSM-01106: MV, string, is stale with respect to some partition(s) in the base table(s)
KUP-04017: OS message: string
ORA-19026: EXTRACTVALUE can only retrieve value of leaf node
ORA-12170: TNS:Connect timeout occurred
TNS-04063: Remote administration disabled in the Oracle Connection Manager instance.
ORA-07620: smscre: illegal database block size
ORA-01010: invalid OCI operation
RMAN-06491: controlfile autobackup format "string" contains more than one "string" format specifier
DRG-11848: Disconnected Operation
Oracle Errors 
