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

NNL-00226: Current request-processing delay is string

ORA-14004: missing PARTITION keyword

TNS-03506: Failed to create address binding

ORA-07226: rtneco: unable to get terminal mode.

ORA-01550: cannot drop system tablespace

ORA-00705: inconsistent state during start up; shut down the instance, then restart it

ORA-19210: column 'string', specified to be a key or update column for DBMS_XMLSTORE, does not not exist in table 'string'

ORA-12224: TNS:no listener

ORA-19729: File string is not the initial version of the plugged in datafile

ORA-07249: slsget: open error, unable to open /proc/pid.

ORA-26679: operation not allowed on LOB or LONG columns in LCR

ORA-06536: IN bind variable bound to an OUT position

For more Oracle Errors Interview Questions Click Here