Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


QSM-01084: materialized view, string, has anchor, string,
not found in query



QSM-01084: materialized view, string, has anchor, string, not found in query..

Answer / guest

Cause: A table in a materialized view is an anchor, (a) if
it is not joined to any other table or (b) joined to other
tables but each of its joins is either lossy or lossless
with the above table being child-side table. If an anchor
which is present in the materialized view is not found in
the query, then query rewrite will not take place.

Action: none

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

TNS-00251: Failure in nstest:

1 Answers  


NNL-00258: Server-generated requests currently do not require authoritative answers

1 Answers  


ORA-00234: error in identifying or opening snapshot or copy controlfile

1 Answers  


ORA-16210: Logical standby coordinator process terminated with error

1 Answers  


ORA-06737: TLI Driver: connection failed

1 Answers  






RMAN-06737: database name "string" does not match target database name "string"

1 Answers  


QSM-02066: Oracle error: see RELATED_NUM and RELATED_TEXT for details

1 Answers  


ORA-38723: Invalid SCN expression.

1 Answers  


ORA-29400: data cartridge error string

1 Answers  


TNS-12661: Protocol authentication to be used

1 Answers  


DRG-11220: Third-party filter is out of memory.

1 Answers  


PLS-00328: A subprogram body must be defined for the forward declaration of string.

1 Answers  






Categories