ORA-30009: Not enough memory for CONNECT BY operation

Cause: The memory size was not sufficient to process all the levels of the hierarchy specified by the CONNECT BY clause.

Action: In WORKAREA_SIZE_POLICY=AUTO mode, set PGA_AGGREGATE_TARGET to a reasonably larger value. Or, in WORKAREA_SIZE_POLICY=MANUAL mode, set SORT_AREA_SIZE to a reasonably larger value.

Error Type: ORA

• Additional information for ORA-30009: Not enough memory for CONNECT BY operation30009
Discussions and solutions for Oracle Database Error ORA-30009: Not enough memory for CONNECT BY operation Developer anwers for Oracle Database Error ORA-30009: Not enough memory for CONNECT BY operation FAQs for ORA-30009: Not enough memory for CONNECT BY operation search others tips for ORA-30009: Not enough memory for CONNECT BY operation