QSM-01040: match between the materialized view (string) and query join graphs f

QSM-01040: match between the materialized view (string) and
query join graphs failed

Question Posted / guest

1 Answers
3293 Views
I also Faced
E-Mail Answers

QSM-01040: match between the materialized view (string) and query join graphs failed..

Answer / guest

Cause: Query rewrite will not take place if the joins in the
query and the materialized view do not have any match.

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

O2F-00340: Name was null

1 Answers

give full details of this ORA-12988: cannot drop column from table owned by SYS

8 Answers Oracle,

ORA-14629: cannot drop the only subpartition of a partition

1 Answers

DRG-11868: Too Many Redirections

1 Answers

ORA-32827: Messaging Gateway agent must be shut down

1 Answers

ORA-06118: NETTCP: unable to complete handshake with ORASRV

1 Answers

DRG-10822: duplicate query name

1 Answers

ORA-13610: The directive string does not exist for task string.

1 Answers

ORA-09702: sem_acquire: cannot acquire latch semaphore

1 Answers

SQL*Loader-00112: Invalid maximum bind array size

1 Answers

PCB-00404: %s

1 Answers

NZE-28774: file cannot write to disk

1 Answers

For more Oracle Errors Interview Questions Click Here