QSM-02034: no joins are present in the HAVING clause



QSM-02034: no joins are present in the HAVING clause..

Answer / guest

Cause: The capability in question is not supported when the
materialized view includes no joins in the HAVING clause.

Action: Re-phrase the query to include a join.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-01635: rollback segment #string specified not available

1 Answers  


ORA-22312: must specify either CASCADE or INVALIDATE option

1 Answers  


ORA-19618: cannot name files after restoreValidate has been called

1 Answers  


PLS-00210: an OTHERS clause is required in this CASE statement

1 Answers  


ORA-24157: duplicate variable name string

1 Answers  






ORA-26677: Streams downstream capture process string cannot proceed

1 Answers  


how to resolve the sqlcode -501 erroe in db2?

2 Answers   Syntel,


TNS-00122: Missing ADDRESS(es) in TNSNET.ORA file

1 Answers  


LPX-00231: invalid character ~1u ('~2c') found in a Name or Nmtoken

1 Answers  


NID-00100: Cannot open datafile "string"

1 Answers  


ORA-00475: TRWR process terminated with error

1 Answers  


QSM-01063: query has a dictionary table or view

1 Answers  


Categories