Hi all,
I want to create a materialized view,which uses
Having count(*)>1 it shows error in this line as

HAVING COUNT(*) > 1
*
ERROR at line 18:
ORA-30353: expression not supported for query rewrite


thanks in advance.