How to reduce and avoid spool space error in Teradata

[iceman23]

Hello,

How will I be able to reduce the Spool of my query below:



LOCKING ROW FOR ACCESS

SELECT

VCCN863.ORDER_I D AS ORDER_ID,
VCCN863.EVENT_O RIGINATOR_NM AS ATTUID,
VCCN863.BAN AS BAN,
VCCN863.EXCEPTI ON_EVENT_TS AS BEGIN_TIME

FROM TELCO_UNREG_RET AIL_VIEWS.VCCN8 63_EXCEPTION_EV ENT_HIST VCCN863
INNER JOIN TELCO_UNREG_RET AIL_VIEWS.VCCN8 63_EXCEPTION_EV ENT_HIST VCCN863_END
ON VCCN863.ORDER_I D = VCCN863_END.ORD ER_ID
and vccn863.EVENT_T YPE_NM = 'Item Pkg'
and vccn863_end.EVE NT_TYPE_NM = 'Item Msg'
and vccn863.package _method_nm = 'Worklist Manager'
INNER JOIN TELCO_UNREG_RET AIL_VIEWS.VCCN8 63_EXCEPTION_EV ENT_HIST VCCN863_END2
on VCCN863_END .order_id = VCCN863_end2.or der_id
and VCCN863_END2.EV ENT_TYPE_NM = 'Item Pkg'
and VCCN863_end2.PA CKAGE_METHOD_NM = 'Assign To Me'


WHERE VCCN863.EXCEPTI ON_EVENT_TS between timestamp '2009-09-05 00:00:00'
and timestamp '2009-09-07 00:00:00'


GROUP BY
VCCN863.ORDER_I D,
VCCN863.EVENT_O RIGINATOR_NM ,
VCCN863.BAN ,
VCCN863.EXCEPTI ON_EVENT_TS ,

ORDER BY 4

[debasisdas]

what exactly you mean by reduce the Spool of my query below ?

[iceman23]

To be able to avoid getting an error of out of spool space error what is the best thing for me to do?

[amitpatel66]

Please post what exactly you tried and what is the error oracle is throwing?

[iceman23]

The error I got was No more Spool space for <USER>

[amitpatel66]

Please provide more insight about the error. Any ORA Error number?