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-24080: unschedule_propagation pending for QUEUE string and DESTINATION string

1 Answers  


ORA-08332: rollback segment #string specified not available

1 Answers  


ORA-31623: a job is not attached to this session via the specified handle

1 Answers  


ORA-14287: cannot REBUILD a partition of a Composite Range partitioned index

1 Answers  


ORA-31078: error in SQL mapping information

1 Answers  






ORA-16132: An error occurred during activation of the standby.

1 Answers  


NZE-29137: The global context is incorrect.

1 Answers  


ORA-37015: (XSACQUIRE_YNRESYNC) Object workspace object is ambiguously listed to be acquired both with and without RESYNC.

1 Answers  


EXP-00038: Bad Hash cluster id in clu$

1 Answers  


ORA-13049: unable to determine tolerance value from table <layer>_SDODIM

1 Answers  


ORA-13011: value is out of range

1 Answers  


ORA-01536: space quota exceeded for tablespace 'string'

3 Answers   Bloom Soft Tech, TCS,


Categories