QSM-02049: subquery using the ANY clause in mv



QSM-02049: subquery using the ANY clause in mv..

Answer / guest

Cause: The capability in question is not supported when the
materialized view uses the ANY clause with a subquery.

Action: Re-phrase the query to avoid the use of the ANY clause.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

O2I-00116: Unable to close the HFILE file

1 Answers  


DRG-11809: Partial Content

1 Answers  


NZE-28808: Cannot retrieve method information from the configuration file.

1 Answers  


ORA-22817: subquery not allowed in the default clause

1 Answers  


ORA-19554: error allocating device, device type: string, device name: string

1 Answers  






ORA-30571: invalid SEGMENT SPACE MANAGEMENT clause

2 Answers  


ORA-23452: flavor string of object group "string"."string" is already published

1 Answers  


ORA-15012: ASM file 'string' does not exist

1 Answers  


QSM-02071: internal error: undefined PCT failure code

1 Answers  


RMAN-05008: SET NEWNAME TO NEW not allowed (datafile string)

1 Answers  


ORA-24077: cannot create propagation schedule for EXCEPTION queue string.string

1 Answers  


DRG-12230: special section name must be one of string

1 Answers  


Categories