alter tablespace temp add tempfile size 1G;
col file_name format a50
col tablespace_name format a20
select tablespace_name, status, file_name, bytes/1024/1024/1024 as GB from dba_temp_files;
alter tablespace temp add tempfile size 1G;
col file_name format a50
col tablespace_name format a20
select tablespace_name, status, file_name, bytes/1024/1024/1024 as GB from dba_temp_files;