存储过程自动备份脚本

#!/bin/bash

source $HOME/.bash_profile

 

today=`date +%Y%m%d`

workdir=$HOME/scripts/bak/proc/

 

proc_bak=$HOME/scripts/bak/proc/proc_bak_$today

cd $workdir

sqlplus -S tpss/AAA@orcl <<EOF

 

 

        set feedback off

        set verify off

        set term off

        set heading off

        set serveroutput on

        set pagesize 0

        set linesize 150

        set trimout on

        set trimspool on

        spool $proc_bak

 

        select sysdate from dual;

 

        select text from user_source a where (name like 'PRO%' or name like 'PRC%') and text is not null;

 

        spool off

exit;

 

EOF