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

ORA-36694: (XSRELTBL01) The value cannot be added to dimension workspace object.

1 Answers  


ORA-01552: cannot use system rollback segment for non-system tablespace 'string'

1 Answers  


ORA-14323: cannot add partition when DEFAULT partition exists

1 Answers  


ORA-04061: existing state of string has been invalidated

1 Answers  


ORA-23321: Pipename may not be null

1 Answers  






PCC-00007: Invalid WHENEVER condition at column number in line number of file string

1 Answers  


ORA-12479: file label string must equal DBHIGH string

1 Answers  


NNO-00055: invalid domain minimum TTL "string"

1 Answers  


ORA-09209: sftget: error reading from file

1 Answers  


NNL-00572: set|show save_config_interval [<seconds>] [<server_list>] : set time of next config save

1 Answers  


ORA-01606: gc_files_to_locks not identical to that of another mounted instance

1 Answers  


ORA-27027: sbtremove2 returned error

1 Answers  






Categories