Query exhaust temp space

Hi All,

This query takes more than 538g of temp space and then it fails with unable to extend error, we have other version of this query  executes well,only for this parameter the query exhausts with temp space /* A.PROJECT_ID LIKE 'NCA12734' and A.ACCOUNTING_DT BETWEEN TO_DATE('2008-01-01','YYYY-MM-DD') AND TO_DATE('2015-03-02','YYYY-MM-DD') */ ,any idea how to fix this issue

INSERT

INTO    PS_Q_CSV_1020_TMP

        (

                SELECT  A.BUSINESS_UNIT     ,

                        X.TREE_NODE         ,

                        C.PRJ_LEVEL1_CF_VAL ,

                        C.PRJ_LEVEL2_CF_VAL ,

                        D.PROJECT_STATUS    ,

                        B.PROJECT_TYPE      ,