查找出无效的数据库对象代码,PLSQL代码库,德仔网

代码语言

代码分类

【PLSQL】查找出无效的数据库对象

作者:Dezai.CN / 发布于2013/5/29/ 1064


	#####################################################################
	##invalid_object_alert.sh
	#####################################################################
	#!/bin/ksh
	EDITOR=vi; export EDITOR
	ORACLE_SID=PPRD10; export ORACLE_SID
	ORACLE_BASE=/data/app/oracle; export ORACLE_BASE
	ORACLE_HOME=$ORACLE_BASE/10.2.0; export ORACLE_HOME
	LD_LIBRARY_PATH=$ORACLE_HOME/lib; export LD_LIBRARY_PATH
	TNS_ADMIN=/var/opt/oracle;export TNS_ADMIN
	NLS_LANG=american; export NLS_LANG
	NLS_DATE_FORMAT='Mon DD YYYY HH24:MI:SS'; export NLS_DATE_FORMAT
	ORATAB=/var/opt/oracle/oratab;export ORATAB
	PATH=$PATH:$ORACLE_HOME:$ORACLE_HOME/bin:/usr/ccs/bin:/bin:/usr/bin:/usr/sbin:/sbin:/usr/openwin/bin:/opt/bin:.; export PATH
	DBALIST="tianlesoftware@vip.qq.com,tianlesoftware@hotmail.com";export DBALIST

	sqlplus -s '/ as sysdba' <<EOF
	set feed off
	set heading off
	column OWNER format a10
	column OBJECT_NAME format a35
	column OBJECT_TYPE format a10
	column STATUS format a10
	spool invalid_object.alert
	SELECT OWNER, OBJECT_NAME, OBJECT_TYPE, STATUS FROM DBA_OBJECTS WHERE STATUS = 'INVALID' ORDER BY OWNER, OBJECT_TYPE, OBJECT_NAME;
	spool off
	exit
	EOF
	if [ `cat invalid_object.alert | wc -l` -gt 0 ] then
	mailx -s "INVALID OBJECTS for PPRD10" $DBALIST < invalid_object.alert
	fi

	$ more invalid_object.alert

	PUBLIC ALL_WM_LOCKED_TABLES SYNONYM INVALID
	PUBLIC ALL_WM_VERSIONED_TABLES SYNONYM INVALID
	PUBLIC DBA_WM_VERSIONED_TABLES SYNONYM INVALID
	PUBLIC SDO_CART_TEXT SYNONYM INVALID
	PUBLIC SDO_GEOMETRY SYNONYM INVALID
	PUBLIC SDO_REGAGGR SYNONYM INVALID
	PUBLIC SDO_REGAGGRSET SYNONYM INVALID
	PUBLIC SDO_REGION SYNONYM INVALID
	PUBLIC SDO_REGIONSET SYNONYM INVALID
	PUBLIC USER_WM_LOCKED_TABLES SYNONYM INVALID
	PUBLIC USER_WM_VERSIONED_TABLES SYNONYM INVALID
	PUBLIC WM_COMPRESS_BATCH_SIZES SYNONYM INVALID

试试其它关键字

　数据库对象　

同语言下

可能有用的

Dezai.CN贡献的其它代码(4037)