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

RMAN-06062: can not backup SPFILE because the instance was not started with SPFILE

1 Answers  


SQL*Loader-00938: partition load requested and string has enabled triggers or constraints

1 Answers  


IMG-00847: area list allocation failed

1 Answers  


ORA-39304: during sync/swap, object "string" conflicts: "string"

1 Answers  


ORA-06744: TLI Driver: listener cannot bind

1 Answers  






ORA-09847: soacon: ARCH unable to open named pipe.

1 Answers  


ORA-24432: The statement that was returned is not tagged.

1 Answers  


ORA-13701: Snapshot pair [string, string] seems to be specified in reverse order.

1 Answers  


ORA-28661: Object already has COMPRESS clause specified

1 Answers  


TNS-00114: Internal error- Allocation of addresses not performed

1 Answers  


NZE-29176: CRL signature verification failed

1 Answers  


ORA-30200: Wrong NLS item was passed into OCINlsGetInfo()

1 Answers  


Categories