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


ORA-30359: Query rewrite is not supported on SYS
materialized views



ORA-30359: Query rewrite is not supported on SYS materialized views..

Answer / guest

Cause: An attempt was made to enable the REWRITE option on a
materialized view in the SYS schema.

Action: Create the materialized view in a different schema
or disable the REWRITE option.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-23605: invalid value "string" for STREAMS parameter string

1 Answers  


NNO-00708: cache flush countdown aborted

1 Answers  


RMAN-06102: no channel to restore a backup or copy of log thread number seq number lowscn string

1 Answers  


ORA-16040: standby destination archive log file is locked

1 Answers  


TNS-12550: TNS:syntax error

1 Answers  






ORA-13291: conversion error between the specified unit and standard unit

1 Answers  


ORA-36674: (XSDPART12) Invalid dimension value starting at string.

1 Answers  


NID-00337: The following datafiles are read-only:

1 Answers  


NNL-00282: Cancelled restart

1 Answers  


CLSR-01009: database management module failed to start

1 Answers  


ORA-30355: materialized view container does not exist

1 Answers  


ORA-10587: Invalid count for ALLOW n CORRUPTION option

1 Answers  






Categories