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 126.96.36.199 and later
Oracle 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.
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.
New functionality Sharded Queues in 12c.
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