QSM-01026: query rewrite is disabled for, string



QSM-01026: query rewrite is disabled for, string..

Answer / guest

Cause: Query rewrite could not use this materialized view,
because query rewrite was not enabled for it.

Action: Enable query rewrite for the materialized view with
ALTER MATERIALIZED VIEW "mv" ENABLE QUERY REWRITE command,
where "mv" is the name of the materializev view.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

NNL-01063: Statistic counters next reset in: string

1 Answers  


ORA-40003: wordsize must be in the range string - string for BLAST-P

1 Answers  


PCB-00236: Cannot use PIC N/G variable. NLS_NCHAR not set or set incorrectly.

1 Answers  


ORA-38713: Flashback Database logging is already turned on.

1 Answers  


ORA-01256: error in locking database file string

1 Answers  






LPX-00102: standalone document declaration should be "no"

1 Answers  


ORA-16749: Resource guard encountered errors in switchover to logical primary

1 Answers  


ORA-25505: the system is not in quiesced state

1 Answers  


ORA-32022: parameter value longer than string characters

1 Answers  


NCR-04012: NCRR: Invalid address descriptor

1 Answers  


ORA-15170: cannot add entry 'string' in directory 'string'

1 Answers  


ORA-09854: snyPortInfo: bad return code from request.

1 Answers  


Categories