alter tablespace TEMP add tempfile '/data/oracle/oradata/orcl/temp02.dbf' size 100m autoextend on;
alter tablespace TEMP drop tempfile '/data/oracle/oradata/orcl/temp01.dbf';
select FILE_NAME,STATUS,AUTOEXTENSIBLE from dba_temp_files;
SELECT * FROM dba_tablespaces;