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


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

QSM-02048: outer join in mv

1 Answers  


ORA-00118: Only one of PROTOCOL, ADDRESS or DESCRIPTION may be specified

1 Answers  


ORA-23443: missing template parameter

1 Answers  


NZE-28760: list creation failure

1 Answers  


TNS-00146: Internal-- Retry data request withing pump.

1 Answers  






ORA-32141: get method does not match the type of the parameter

1 Answers  


NNF-01005: Internal XOM class violation

1 Answers  


ORA-24377: invalid OCI function code

1 Answers  


RMAN-03023: executing command: string

1 Answers  


ORA-08112: a composite partition may not be coalesced as a whole

1 Answers  


ORA-08342: sropen: failed to open a redo server connection

1 Answers  


ORA-21614: constraint violation for attribute number [string]

1 Answers  






Categories