Shrinking a Locally Managed Temporary Tablespace

Just stumbled on the shrink command for the temp tablespace, I normally just do a reisze of the datafile but just tested the command and it works great! Test SYS@testdb1> Select tablespace_name, file_name, bytes/1024/1024 “Size MB”,AUTOEXTENSIBLE, MAXBYTES/1024/1024 “Auto MB” from dba_temp_files; TABLESPACE_NAME    FILE_NAME                       […]