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-00007: Invalid WHENEVER condition at column number in line number of file string

LPX-00405: unable to allocate memory

ORA-25301: cannot specify recipient list during enqueue

DRG-50600: assertion failed

ORA-00828: specified value of shared_pool_reserved_size inconsistent with internal settings

ORA-07210: slcpu: getrusage error, unable to get cpu time.

NNL-00985: Requests reforwarded using referrals: number

ORA-30459: 'string.string' cannot be refreshed because the refresh method is NONE

NZE-28852: Bad password

ORA-36672: (XSDPART10) A RANGE or LIST PARTITION TEMPLATE can only have a single partition dimension.

NNL-00548: Displays update request statistics

DRG-51020: out of memory in fuzzy matcher

For more Oracle Errors Interview Questions Click Here