Oracle Solution for Error ora-42013
ORA-42013: interim table of an AQ IOT table should be an IOT table
What triggered 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).
What should we do to fix it:
Ensure that the interim table is created as an IOT table.