Oracle Error Message
ORA-30930: NOCYCLE keyword is required with CONNECT_BY_ISCYCLE pseudocolumn
Reason for the Error
CONNECT_BY_ISCYCLE was specifed in a query which does not have the NOCYCLE keyword.
Solution
Remove CONNECT_BY_ISCYCLE or add NOCYCLE.