Oracle Message QSM-02012 - a CONNECT BY clause is present

ERRORa CONNECT BY clause is present
CAUSEThe capability in question is not supported when the materialized view uses a CONNECT BY clause.
ACTIONRe-phrase the query to avoid use of the CONNECT BY clause.