ORA-12079: materialized view options require COMPATIBLE parameter to be string

ORA-12079: materialized view options require COMPATIBLE
parameter to be string or greater

Question Posted / guest

ORA-12079: materialized view options require COMPATIBLE parameter to be string or greater..

Answer / guest

Action: Shut down and restart with an appropriate
compatibility setting.

Please add more information about this Error

Is This Answer Correct ?

0 Yes

0 No

More Oracle Errors Interview Questions

PLS-00722: supertypes's AUTHID is different than subtype's AUTHID

ORA-19007: Schema string does not match expected string.

ORA-27007: failed to open file

ORA-02203: INITIAL storage options not allowed

ORA-02154: a tablespace with the name 'string' is found

ORA-24757: duplicate transaction identifier

DRG-11846: Response Is Stale

ORA-02813: Unable to make temporary file name in order to get key

ORA-07402: sprst: cannot restore user signal handler.

RMAN-06480: WARNING: archivelog 'string' cannot be found on disk

ORA-16547: cannot disable the primary database

ORA-01277: file 'string' already exists

For more Oracle Errors Interview Questions Click Here