Bug 18268753 View AQ$<queue_name> Invalid After Creating Sharded Queue
(Doc ID 1675479.1)
Last updated on JUNE 15, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.1 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
On successful execution of DBMS_AQADM.CREATE_SHARDED_QUEUE to create a sharded queue, a view is automatically created with with naming convention AQ$<queue name>. However, this view was created with the following compilation errors, and the status of this view is INVALID in DBA_OBJECTS:
ORA-54039: table must have at least one column that is not invisible
ORA-00904: "QT_L"."SUBSCRIBER#": invalid identifier
On successful execution of DBMS_AQADM.DROP_SHARDED_QUEUE to drop the sharded queue, the view is not dropped as expected but remains in INVALID state.
The problem is specific to single consumer sharded queues; it does not reproduces in multiconsumer queue.
Changes
New functionality Sharded Queues in 12c.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |