ORA-24057: cannot define subscriber with rule for queue string
- 1 Answers
- 2658 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-02154: a tablespace with the name 'string' is found
NZE-28839: no persona descriptor
ORA-37060: (XSMCSESS08) number is not a valid custom member in dimension workspace object.
RMAN-06129: invalid reserved channel ID: string
ORA-32162: Read/Write SQL method not registered
KUP-04074: no write access to directory object string
ORA-32823: subscriber exists for queue string and destination string
ORA-12800: system appears too busy for parallel query execution
ORA-28671: UPDATE BLOCK REFERENCES may not be used on a partitioned index as a whole
ORA-12830: Must COMMIT or ROLLBACK after executing parallel INSERT/UPDATE/DELETE
ORA-16814: incorrect log transport setting for standby's AlternateLocation
RMAN-06131: skip offline/readonly only allowed with current controlfile
Oracle Errors 
