My Oracle Support Banner

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 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.