QSM-02179: MV with UNION ALL requires compatibility >= 9.2



QSM-02179: MV with UNION ALL requires compatibility >= 9.2..

Answer / guest

Cause: The setting of the COMPATIBLE initialization
parameter is less than 9.2.0.

Action: Set COMPATIBLE to 9.2.0 or higher.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-01675: max_commit_propagation_delay inconsistent with other instances

1 Answers  


NCR-03017: NCRO: Transport type RSLV not supported

1 Answers  


RMAN-08089: channel string: specifying datafile(s) to restore from backup set

1 Answers  


ORA-07683: sou2os: $SETPRV reset error

1 Answers  


PCC-00060: Both CURSOR and STATEMENT have AT clauses at line number of file string.

1 Answers  






PCC-00118: Use of host variable initialization not supported by ANSI SQL

1 Answers  


NZE-28845: No certificate

1 Answers  


ORA-28653: tables must both be index-organized

1 Answers  


PROT-00016: Internal Error

1 Answers  


RMAN-06910: can not invoke parallel recovery for test recovery

1 Answers  


ORA-16700: The standby database has diverged from the primary database.

1 Answers  


ORA-30486: invalid window aggregation group in the window specification

1 Answers  


Categories