Editing ray

Title / Description

Code
-- 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

Author

Highlight as C C++ CSS Clojure Delphi ERb Groovy (beta) HAML HTML JSON Java JavaScript PHP Plain text Python Ruby SQL XML YAML diff code