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

PCC-02364: Host struct and its indicator must have the same number of fields

TNS-12206: TNS:received a TNS error during navigation

ORA-26078: file "string" is not part of database being loaded

ORA-27366: job "string.string" is not running

LSX-00343: "~S" is not nillable

DRG-11733: more than one translation for the term in the specified language

PLS-01900: : character to number conversion error

PCC-02066: CMD-LINE: Could not find or could not open system config file

SQL*Loader-00108: Invalid number of logical records to load

ORA-36260: (XSAGHIERPART00) Aggregating from partition %J to partition %J over hierarchy workspace object creates an increase in sparsity.

TNS-00042: INTCTL: CMANAGER already running. Start operation cancelled

DRG-11122: unsupported section group

For more Oracle Errors Interview Questions Click Here