|
/****************************************** pro.sh ***********************************************************/
##用于编译视图和脚本的sql脚本
#Set ORACLEenvironment
ORACLE_HOME=/home/oracle/OraHome1/product
export ORACLE_HOME
ORACLE_SID=oradbyj
export ORACLE_SID
/home/oracle/OraHome1/product/bin/sqlplus vipdl/vipdl123 @/home/oracle/jobs/pro.
sql
/home/oracle/OraHome1/product/bin/sqlplus vipdl/vipdl123 @/home/oracle/jobs/view
.sql
/*****************************************pro.sql *************************************************************/
set feedback off
set heading off
spool /home/oracle/jobs/pro2.sql;
select 'alter procedure 'OBJECT_NAME' compile;' from sys.all_probe_objects w
here OWNER='VIPDL' and OBJECT_TYPE='PROCEDURE' and STATUS='INVALID';
spool off;
@/home/oracle/jobs/pro2.sql;
exit;
/****************************************view.sql*************************************************************/
set feedback off
set heading off
spool /home/oracle/jobs/view2.sql;
select 'alter view 'OBJECT_NAME' compile;' from sys.all_probe_objects where
OWNER='VIPDL' and OBJECT_TYPE='VIEW' and STATUS='INVALID';
spool off;
@/home/oracle/jobs/view2.sql;
exit;
/***************************************crontab**************************************************************/
#
#将以上脚本加入定时触发器
#
20 02 * * * /home/oracle/jobs/Vpmn_sell.sh
30 05 * * * /home/oracle/jobs/Alert_everyday.sh
30 21 * * * /home/oracle/jobs/vipback.sh
30 23 * * 0,1,3,5 /home/oracle/jobs/ftp.sh
30 17 * * * /home/oracle/jobs/pro.sh
/////////////////////////////////////////////////////// 完 ///////////////////////////////////////////////////////////////////////////////////////////
(出处:清风网络学院)
上一篇:在 Red Hat Linux 9.0 上安装 Oracle 8i
下一篇:生成带日期的文件名
|