ORA-24057: cannot define subscriber with rule for queue string
- 1 Answers
- 2674 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 |
ORA-29822: selectivity cannot be specified for the type of object
ORA-29805: missing COLUMN keyword
ORA-29296: invalid encoded string
NNL-00003: memory exhausted
ORA-02471: SYSDATE, UID, USER, ROWNUM, or LEVEL incorrectly used in hash expre\ssion.
NNL-00974: Name: string
ORA-31027: Path name or handle string does not point to a resource
ORA-07671: $IDTOASC failed translating an integrity category
RMAN-06129: invalid reserved channel ID: string
ORA-30486: invalid window aggregation group in the window specification
PLS-00337: "string" matches too many object table aliases
QSM-01063: query has a dictionary table or view
Oracle Errors 
