Bug 18268753 View AQ$<queue_name> Invalid After Creating Sharded Queue
Last updated on FEBRUARY 23, 2017
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms