QSM-02017: subquery present in the HAVING clause



QSM-02017: subquery present in the HAVING clause..

Answer / guest

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

Action: Re-phrase the query to avoid the subquery 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

ORA-19756: corrupt block number string found in change tracking file

1 Answers   Scope International,


RMAN-10014: PL/SQL error number on line number column number: string

1 Answers  


RMAN-06744: specification does not match any datafilecopy in the repository

1 Answers  


SQL*Loader-00135: Invalid argument for RESUMABLE

1 Answers  


PLS-00662: Non-external object types containing external mapped attributes are not allowed

1 Answers  






SQL*Loader-00200: FORMAT clause should not be present - flat data files only

1 Answers  


ORA-23444: duplicate template parameter

1 Answers  


IMG-00541: invalid contentFormat specified

1 Answers  


ORA-01093: ALTER DATABASE CLOSE only permitted with no sessions connected

2 Answers  


ORA-36962: (XSRELTBL08) string is not a valid qualified data reference for dimension workspace object.

1 Answers  


ORA-38425: attribute set used for an index object may not be unassigned

1 Answers  


ORA-31641: unable to create dump file "string"

1 Answers  


Categories