DROP

To drop a temporary tablespace...

DROP TABLESPACE mytempts;

Autoextend

Check AutoExtend

COLUMN file_name FORMAT a30

SELECT file_name, tablespace_name, autoextensible

FROM dba_temp_files;

Enable Autoextend

ALTER DATABASE TEMPFILE '/u02/oradata/MYSID/datafile/MYTEMPDF.tmp' AUTOEXTEND ON;

Disable Autoextend

ALTER DATABASE TEMPFILE '/u02/oradata/MYSID/datafile/MYTEMPDF.tmp' AUTOEXTEND OFF;