ORA-942 on AQ Propagation with Type Requiring STORAGE_CLAUSE NESTED TABLE (Doc ID 1986196.1)

Last updated on MAY 04, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 to 12.1.0.2 [Release 11.2 to 12.1]
Information in this document applies to any platform.

Symptoms

ora-942 encountered on propagation AQ propagation.

Queue table created as follows :

  DBMS_AQADM.CREATE_QUEUE_TABLE
  (QUEUE_TABLE => 'TEST_TAB'
  ,QUEUE_PAYLOAD_TYPE => 'ACU_MSG_TYPE'
  ,storage_clause => 'Nested Table user_data.binaryData Store AS binaryDataTable'  <<<
  ,MULTIPLE_CONSUMERS => TRUE);


Stack generated from propagation job is :

...
[06]: npierr []<-- Signaling
[07]: kpnerr []
[08]: kpnpst []
[09]: upirtrc []
[10]: kpurcsc []
[11]: kpurcsenq []
[12]: kpuenqarray []
[13]: OCIAQEnqArray []
[14]: kwqpstrmmsg0 [AQ]
[15]: kwqpdest [AQ]
[16]: kwqjswucb [AQ]
[17]: rpiswu2 []
[18]: kwqjpropwin [AQ]
...

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