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-15007: name is already used by an existing template

1 Answers  


ORA-13241: specified dimensionality does not match that of the data

1 Answers  


ORA-02256: number of referencing columns must match referenced columns

1 Answers  


UDE-00001: user requested cancel of current operation

1 Answers  


ORA-30357: this PL/SQL function cannot be supported for query rewrite

1 Answers  






ORA-25278: grantee name cannot be NULL

1 Answers  


ORA-01262: Stat failed on a file destination directory

1 Answers  


RMAN-20205: incomplete UNTIL clause

1 Answers  


TNS-00213: Available Connections : number

1 Answers  


ORA-27417: BYWEEKNO clause is only supported when FREQ=YEARLY

1 Answers  


ORA-19596: SPFILE already included

1 Answers  


ORA-31423: change table string does not contain column string

1 Answers  


Categories