Oracle Error ORA-42013: interim table of an AQ IOT table should be an IOT table

Oracle Error Message

ORA-42013: interim table of an AQ IOT table should be an IOT table

Reason for the Error

An attempt was made to create a table that is not an index-organized table (IOT) as the interim table of an AQ IOT table (history, time management, or dequeue).

Solution

Ensure that the interim table is created as an IOT table.