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-06107: NETTCP: ORACLE network server not found

1 Answers  


DRG-10315: logging is not supported on MTS

1 Answers  


TNS-12160: TNS:internal error: Bad error number

1 Answers  


QSM-01048: join back level(s) not present (string)

1 Answers  


PLS-01402: Use of quoted identifier

1 Answers  






ORA-36272: (XSCGMDLAGG04) 'workspace object' is not a valid operator for the AGGREGATION function.

1 Answers  


ORA-25454: error during evaluation of rule set: string.string for iterator: string

1 Answers  


O2F-00315: An attribute of a type is listed twice in a type specification

1 Answers  


ORA-28265: NameSpace beginning with 'sys_' is not allowed

1 Answers  


ORA-01352: tablespace given for Logminer spill does not exist

1 Answers  


ORA-32831: timed out trying to acquire administration lock

1 Answers  


ORA-13380: network not found

1 Answers  


Categories