QSM-02058: set operator in mv and compatibility mode is less
than 9.0



QSM-02058: set operator in mv and compatibility mode is less than 9.0..

Answer / guest

Cause: The capability in question is not supported when the
materialized view uses a set operator and the compatibility
mode is less than 9.0.

Action: Re-phrase the query to avoid the use of set
operators or set the compatibility mode to 9.0 or greater.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

PCC-00068: Host and indicator variables may not have the same name.

1 Answers  


ORA-15011: failure group "string" contains no members

1 Answers  


IMP-00063: Warning: Skipping table "string"."string" because object type "string"."string" cannot be created or has different identifier

0 Answers  


invalid quantity specification negative quantity are not allowed for this item please check this item definition quantity

0 Answers  


EXP-00021: can only perform incremental export in Full Database mode

1 Answers  






ORA-27033: failed to obtain file size limit

1 Answers  


IMG-00811: fail queue initialization failed

1 Answers  


ORA-16058: standby database instance is not mounted

1 Answers  


LSX-00293: missing one or more fields from element "~S"

1 Answers  


RMAN-20261: ambiguous backup piece handle

1 Answers  


EXP-00025: dictionary shows no column for constraint string.number

1 Answers  


ORA-16749: Resource guard encountered errors in switchover to logical primary

1 Answers  


Categories