QSM-02124: object type in WHERE clause



QSM-02124: object type in WHERE clause..

Answer / guest

Cause: The capability in question is not supported when the
materialized view references an object type in the WHERE clause.

Action: Re-phrase the query to avoid the reference to the
object type.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-23371: column string unknown in table string

1 Answers  


ORA-01093: ALTER DATABASE CLOSE only permitted with no sessions connected

2 Answers  


ORA-01512: error renaming log file string - new file string not found

1 Answers  


ORA-39006: internal error

1 Answers  


ORA-01071: cannot perform operation without starting up ORACLE

1 Answers  






DRG-10511: index string does not exist or is incomplete

1 Answers  


ORA-28668: cannot reference mapping table of an index-organized table

1 Answers  


ORA-23605: invalid value "string" for STREAMS parameter string

1 Answers  


ORA-07489: scgrcl: cannot get lock status.

1 Answers  


TNS-12526: TNS:listener: all appropriate instances are in restricted mode

1 Answers  


ORA-29662: Unable to find a field that matches one or more of the attributes

1 Answers  


RMAN-06402: Oracle instance shut down

1 Answers  


Categories