Install Database Objects

Code:

#!/usr/bin/env bash
source=install.dat
echo "" > ${source}
for directory in `echo "pre_install privilege role sequence table temp_table \
index constraint_pk constraint_other constraint_fk type \
package view package_body trigger context procedure \
function seed_data schedule job synonym grant rest_module \
post_install"`
do
   ddl=`find ${directory}/*.sql print 2>/dev/null  `
   if [ ! -z "${ddl}" ] ; then
       echo "-- Processing ${directory}"  >> ${source}
       echo "${ddl}"                      >> ${source}
   fi
done
echo "" > install.sql
for line in `cat ${source} | grep -v ^-- `
do
  echo "@${line}" >> install.sql
done

sql -S user/password@database <<EOF
  spool install.log
  @install.sql
  spool off
EOF
#
#
# _EOF