Oracle Error ORA-32035: unreferenced query name defined in WITH clause

Oracle Error Message

ORA-32035: unreferenced query name defined in WITH clause

Reason for the Error

There is at least one WITH clause query name that is not referenced in any place.

Solution

remove the unreferenced query name and retry