ORA-24057: cannot define subscriber with rule for queue string
- 1 Answers
- 2965 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 |
PCC-02305: illegal mixing of new and old style C function declarations
ORA-12317: logon to database (link name string) denied
ORA-00276: CHANGE keyword specified but no change number given
ORA-14171: cannot specify <subpartition-description> clause in CREATE|ALTER TABLE
ORA-26002: Table string has index defined upon it.
ORA-01678: parameter string must be pairs of pattern and replacement strings
RMAN-06206: Crosschecked string objects
ORA-01119: error in creating database file 'string'
ORA-13625: %s is an invalid advisor object type.
TNS-01109: Listener password encryption failed
PCC-02318: missing type expression
ORA-12804: parallel query server appears to have died
Oracle Errors 
