set line 199
col file_name format a50
select tablespace_name,file_name,bytes/1024/1024 file_size,autoextensible from dba_temp_files;
alter tablespace temp add tempfile size 100m;
select tablespace_name,file_name,bytes/1024/1024 file_size,autoextensible from dba_temp_files;
alter database tempfile '/data/XBLTESTBAK/datafile/o1_mf_temp_k772kbnt_.tmp' drop;
select tablespace_name,file_name,bytes/1024/1024 file_size,autoextensible from dba_temp_files;
ORA-01157 & ORA-01110
select file_name, tablespace_name from dba_temp_files;