Database Runs out of Temp Space
Hi Gurus,
My 10.2.0.3 database runs out of TEMP space while executing below sql. I had added space to Temporary tablespace but still fails. Temporary tablespace is already 23 GB. Any ideas how to go about this?
select A1.SEND_OUT_CODE,A1.APPLICANT_ID,A1.APPLICANT_JBE_ID,A1.COUNTRY_CODE,Case when year(A1.DATE_CLICKED) <= 1800 then null else A1.DATE_CLICKED end as DATE_CLICKED,
A1.UNKNOWN,A1.MOREVACS,A1.MYPROFILE,A1.CANCEL,A1.HOME,A1.APPLY,A1.REMIND,A1.VACANCY,A1.PRIVACY,A1.TERMS,A1.OPENTOP,A1.OPENBOTTOM,A1.POS1,A1.POS2,A1.POS3,A1.POS4,A1.POS5,
My 10.2.0.3 database runs out of TEMP space while executing below sql. I had added space to Temporary tablespace but still fails. Temporary tablespace is already 23 GB. Any ideas how to go about this?
select A1.SEND_OUT_CODE,A1.APPLICANT_ID,A1.APPLICANT_JBE_ID,A1.COUNTRY_CODE,Case when year(A1.DATE_CLICKED) <= 1800 then null else A1.DATE_CLICKED end as DATE_CLICKED,
A1.UNKNOWN,A1.MOREVACS,A1.MYPROFILE,A1.CANCEL,A1.HOME,A1.APPLY,A1.REMIND,A1.VACANCY,A1.PRIVACY,A1.TERMS,A1.OPENTOP,A1.OPENBOTTOM,A1.POS1,A1.POS2,A1.POS3,A1.POS4,A1.POS5,
0