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-07285: sksaprd: volume size should not be specified for a disk file.

1 Answers  


ORA-39002: invalid operation

1 Answers  


LSX-00262: attribute "~1S" cannot have complex type "~2S"

1 Answers  


ORA-01082: 'row_locking = always' requires the transaction processing option

1 Answers  


RMAN-08102: channel string: located backup piece: string

1 Answers  






ORA-32307: must use FROM ONLY clause when referencing an object table

1 Answers  


QSM-00757: the specified workload string is not referenced by task string

1 Answers  


ORA-30461: 'string.string' cannot be refreshed because it is marked DISABLED

1 Answers  


LPX-00303: attribute value "~S" not expected for ~S

1 Answers  


PCB-00500: No EXEC SQL CONTEXT USE statement encountered

1 Answers  


ORA-32101: cannot create OCI Environment

1 Answers  


ORA-07282: sksaprd: string overflow.

1 Answers  


Categories