[SQLPLUS] 生成批量数据库维护脚本

- 以下脚本可以在shell中调用实现自动化
- aaa.sql中生成维护脚本

sqlplus -s "/as sysdba"

set echo off
set feedback off
set newpage none
set pagesize 5000
set linesize 500
set verify off
set pagesize 0
set term off
set trims on
set linesize 600
set heading off
set timing off
set verify off
set numwidth 38

spool aaa.sql
SELECT 'DELETE '|| table_name ||';' from dba_tables where owner='GO';
spool off

exit