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

RMAN-06109: changed archive log unavailable

PROC-00029: Error in logging layer

PCC-00122: Input file name and output file name are identical

TNS-12502: TNS:listener received no CONNECT_DATA from client

RMAN-06547: tablespace SYSTEM cannot be excluded from whole database backup

NNL-01006: META VIOLATION responses received: number

ORA-16053: DB_UNIQUE_NAME string is not in the Data Guard Configuration

NNO-00059: cannot construct topology checkpoint file name

ORA-19725: can not acquire plug-in enqueue

PLS-00520: MAP methods must be declared without any parameters other than (optional) SELF.

TNS-01016: change_password [<listener_name>]: changes the password of the listener

ORA-32816: foreign queue string is referenced by a subscriber or schedule

For more Oracle Errors Interview Questions Click Here