smart_update.sh 241 B

1234567
  1. #!/bin/ksh
  2. export ORACLE_SID=`echo ${1} | tr [:lower:] [:upper:]`
  3. export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1/
  4. export SCRIPTS="/home/oracle/LJ/smart_update"
  5. $ORACLE_HOME/bin/sqlplus / as sysdba @${SCRIPTS}/SMART_UPDATES.SQL