TEMP Tablespace full - Oracle 9i
Hi There,
Currently our production database is showing the Temp Tablespace filled by 99.97%.
We are using Oracle 9i Enterprise Edition Release 9.2.0.7.0 - Production.
We got the following error message when the monthly job was archiving the Audit Trails to the ARCHIVE schema:-
ORA-01652: unable to extend temp segment by 128 in tablespace ARCHIVE
On investigation we found that we didn't have enough space on ARCHIVE schema because of which the job failed.
Could you please guide us if we need to do anything to get the space released on TEMP tablespace as we don't want to increase the size of TEMP tablespace unnecessarily.
Currently our production database is showing the Temp Tablespace filled by 99.97%.
We are using Oracle 9i Enterprise Edition Release 9.2.0.7.0 - Production.
We got the following error message when the monthly job was archiving the Audit Trails to the ARCHIVE schema:-
ORA-01652: unable to extend temp segment by 128 in tablespace ARCHIVE
On investigation we found that we didn't have enough space on ARCHIVE schema because of which the job failed.
Could you please guide us if we need to do anything to get the space released on TEMP tablespace as we don't want to increase the size of TEMP tablespace unnecessarily.
0