Cause
CONNECT BY could not be used on a view where there was not a correspondence between output rows and rows of the underlying table.
Action
Remove the DISTINCT or GROUP BY from the view or move the CONNECT BY clause into the view.
Oracle 26ai
ORA-01472
Error Message
cannot use CONNECT BY on view with DISTINCT, GROUP BY, etc.