If you are trying to debug error ORA-01436: CONNECT BY loop in user data in the CONNECT BY sql statements, the following might help you: ALTER SESSION SET "_dump_connect_by_loop_data"=TRUE; — execute the CONNECT BY here Now look in the UDUMP destination for the trace file, it will contain the problematic IDs which are causing the [...]