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



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

Answer / guest

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

Action: Remove the reference to the Index Organized Table.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-38605: FI not enough memory(stringK) for candidate generation(stringK)

1 Answers  


ORA-33080: (XSAGDNGL40) In AGGMAP workspace object, you cannot reference dimension workspace object with both a RELATION statement and a DIMENSION statement.

1 Answers  


ORA-25147: UNIFORM SIZE value greater than maximum extent size

1 Answers  


QSM-00507: no dimensions could be found

1 Answers  


ORA-14106: LOGGING/NOLOGGING may not be specified for a clustered table

1 Answers  






ORA-10616: Operation not allowed on this tablespace

1 Answers  


ORA-31464: target table for the change table no longer exists

1 Answers  


QSM-01047: complex join back on non-MAV rewrite not allowed (string)

1 Answers  


TNS-00508: No such protocol adapter

1 Answers  


ORA-23388: replication parallel push watermark error

1 Answers  


ORA-24163: dblink is not supported in rules engine DDLs

1 Answers  


RMAN-20218: datafile not found in recovery catalog

1 Answers  


Categories