ORA-24038: RETRY_DELAY and MAX_RETRIES cannot be used for a
8.0 compatible multiple consumer queue
Answer / guest
Cause: The CREATE_QUEUE or ALTER_QUEUE command was issued
with a non-zero RETRY_DELAY and a QUEUE_TABLE that was
created for multiple consumers and with COMPATIBLE parameter
set to '8.0'.
Action: Either set the RETRY_DELAY to zero or upgrade the
queue table to 8.1 compatible using the
DBMS_AQADM.MIGRATE_QUEUE_TABLE procedure.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-01969: You must specify RESETLOGS or NORESETLOGS
ORA-24382: statement handled already executed or described
ORA-14159: duplicate subpartition name
ORA-12710: CREATE CONTROLFILE character set is not known
TNS-00234: Connect data for failed call: CALL DATA = string RECEIVE DATA = :string:
ORA-02380: profile string does not exist
PCB-00552: The SQLCA and a SQLCODE variable cannot both be used
ORA-13263: column string in table string is not of type SDO_GEOMETRY
SQL*Loader-00410: Number to skip must be load-level, not table-level
ORA-16606: unable to find property "string"
ORA-01137: data file string is still in the middle of going offline
SQL-02128: Sessions still exist, not logged off