Oracle Technology Blog

OraTech Blog provides tips,tricks,scripts and how-to type answers for Oracle related technologies. I use these commands very often, so I thought it would be useful to share with everybody. Please feel free to include your comments/corrections/questions.

Friday, December 22, 2006

SQL background execution

cat exec.sh
x=`${ORACLE_HOME}/bin/dekr /export/home/oracle/scripts/dba/.Schedulejobs/perf.dat`
${ORACLE_HOME}/bin/sqlplus -s <<EOS
username/password
set pages 200 lines 130
set long 50000
start script_name.sql
exit;
EOS


posted by Sami @ 9:30 AM 

0 Comments:

Post a Comment

<< Home