oracle sql

-- script para eliminar el datafile temp original y crear otro mas reducido

set pagesize 0
set linesize 32000
set heading off
set feed off
set echo off
set termout off
set verify off
set trimspool on



spool sql_drop_tmp.sql

select 'alter database TEMPFILE ' || chr(39) || tab.file_name || chr(39)  || ' OFFLINE; 'FROM dba_temp_files tab;
select 'alter tablespace TEMP drop tempfile ' || chr(39) || tab.file_name || chr(39) || '; ' FROM dba_temp_files tab;

spool off

alter tablespace TEMP add tempfile  SIZE 1G AUTOEXTEND ON NEXT 100M MAXSIZE 8G;

set echo on
set termout on
@sql_drop_tmp.sql