While looking available options to shrink temp tablespace, i found the following options, i found 1st one easiest. I want to know difference b/t them.
ALTER TABLESPACE TEMP SHRINK SPACE;
ALTER DATABASE TEMPFILE ‘/orcl/tempfile/temp.dbf′ RESIZE 200M;
ALTER TABLESPACE TEMP SHRINK TEMPFILE ‘/orcl/tempfile/temp.dbf′ KEEP 100M;