QSM-02022: aggregate selections



QSM-02022: aggregate selections..

Answer / guest

Cause: The capability in question is not supported when the
materialized view uses an aggregate expression in the HAVING
clause.

Action: Re-phrase the query to avoid the use of an aggregate
in the HAVING clause.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

EXP-00029: Incremental export mode and consistent mode are not compatible

1 Answers  


LFI-00106: Path object holds more than one path.

1 Answers  


ORA-21614: constraint violation for attribute number [string]

1 Answers  


ORA-06764: TLI Driver: error reading disconnect

1 Answers  


TNS-04023: Command failed.

1 Answers  






ORA-23408: this replication operation is not supported in a mixed configuration

1 Answers  


ORA-00088: command cannot be executed by shared server

1 Answers  


ORA-02333: cannot create constraints on attributes of this column

1 Answers  


ORA-27015: skgfcls: failed to close the file

1 Answers  


ORA-19715: invalid format string for generated name

1 Answers  


ORA-01190: controlfile or data file string is from before the last RESETLOGS

1 Answers  


ORA-06042: NETDNT: message receive failure

1 Answers  


Categories