TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE
------------------------------ ---------------- ---------------- ----------------
TEMP1 5,776,596,992 1,296,031,744 4,480,565,248
suppose I have a temp tablespace with 1 file , how much space I could shrink using
alter tablespace TEMP1 shrink space keep 2G;
ALTER TABLESPACE TEMP1 SHRINK TEMPFILE '/data/temp1.dbf' KEEP 2G;
ALTER TABLESPACE TEMP1 SHRINK TEMPFILE '/data/temp1.dbf' ;
alter database tempfile '/data/temp1.dbf' resize 2G;
non of the above work. How can I know how much I can shrink ??