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-00236: Invalid external type specification for string.

NZE-28820: Signature or decryption/encryption state is not provided.

RMAN-20222: datafilename not found in recovery catalog or is ambiguous

ORA-31671: Worker process string had an unhandled exception.

ORA-01666: controlfile is for a standby database

ORA-16515: no rcv channel

NMP-00002: no such SNMP variable name

ORA-00972: identifier is too long

ORA-28166: duplicate rolename in list

PCB-00214: JUSTIFIED clause not allowed for host variable "string"

ORA-32009: cannot reset the memory value for instance string from instance string

ORA-33332: (DSSEXIST01) Use the AW command to establish a current analytic workspace. Then start your current activity again.

For more Oracle Errors Interview Questions Click Here