TEMP tablespace full and doesnt get cleared
Hi we are facing space issues in our PROD environment related to TEMP tablespace and its details are below Tablespace
Tablespace Size (MB) Free (MB) % Free % Used
------------------------------ ---------- ---------- ---------- ----------
TEMP2 8000 0 0 100
TEMP2 1024 0 0 100
TEMP1 8192 0 0 100
TEMP2 4096 0 0 100
Tablespace Size (MB) Free (MB) % Free % Used
------------------------------ ---------- ---------- ---------- ----------
TEMP1 1100 0 0 100
TEMP1 4096 0 0 100
TEMP2 4096 0 -95 100
TEMP1 4096 0 -100 100
TEMP1 1100 0 -272 100
TEMP2 1024 0 -300 100
TEMP1 1100 0 -645 100
TEMP2 1024 0 -681 100
can someone give any idea apart from extending tablespace ?
why does free space is showing in minus?
what needs to be cleared to get free space in TEMP?
thanks
shabz