# # Script used to run cdmsp_dynamic_ndx_rebuild.sql # To be used only the oracle Account # # Ensure that the running user is oracle oracle_user=`/usr/ucb/whoami|grep oracle|grep -v grep|wc -l`; oracle_num=`expr $oracle_user` if [ $oracle_num -lt 1 ] then echo " Current User is not oracle. Please su to oracle and retry." sleep 5 exit else # Set Oracle Environment variables # ORACLE_SID=cdmsp ORACLE_HOME=`/u01/oracle/OraHome1/bin/dbhome cdmsp` PATH=/u01/oracle/OraHome1/bin:/bin:/usr/bin:/usr/ccs/bin:/opt/bin export ORACLE_SID export ORACLE_HOME export PATH # # # Connect to SQLPLUS with a privileged account sqlplus "/ as sysdba" 1> $1 2> $2<