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

PLS-00524: The parameter type in an ORDER method must be the containing object type.

1 Answers  


TNS-01201: Listener cannot find executable string for SID string

1 Answers  


RMAN-08583: channel string: archivelog copy complete, elapsed time: string

1 Answers  


SQL*Loader-00422: constant element count of number for column string is greater than maximum, number

1 Answers  


ORA-02141: invalid OFFLINE option

1 Answers  






SQL*Loader-00948: subpartition string not part of table string

1 Answers  


PCC-02206: Host variables are not permitted within a DDL statement

1 Answers  


QSM-02031: materialized view cannot support any type of query rewrite

1 Answers  


ORA-19635: input and output filenames are identical: string

1 Answers  


NNL-00853: Renames refused, new name already exists: number

1 Answers  


ORA-01614: instance string (thread string) is busy - cannot enable

1 Answers  


ORA-23306: schema string does not exist

1 Answers  


Categories