Bug 18268753 View AQ$<queue_name> Invalid After Creating Sharded Queue (Doc ID 1675479.1)

Last updated on FEBRUARY 23, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms