Oracle Error QSM-02015: Index Organized Table (IOT) present in FROM list

Oracle Error Message

QSM-02015: Index Organized Table (IOT) present in FROM list

Reason for the Error

The capability in question is not supported when the materialized view references an Index Organized Table in the FROM list.

Solution

Remove the reference to the Index Organized Table.