Oracle Error Message
ORA-30928: Connect by filtering phase runs out of temp tablespace
Reason for the Error
It is probably caused by the fact that there is a loop in the data.
Solution
Please retry the query with the NO_FILTERING hint. If the same error still occurs, then increase temp tablespace.