#!/bin/ksh

export ORACLE_BASE=/oracle
export ORACLE_HOME=/oracle/product/7.3.3
export ORACLE_SID=dojv
PATH=$PATH:~:$ORACLE_HOME/bin:/etc

svrmgrl command=@viw0 # produces: viw0.log

viw0.pl > viw1.sql

svrmgrl command=@viw1 # produces: viw1.log

# contained in viw1.pl: $x=`grep "^#" viw1.log | sort +3n -r > viw.rm0`; 

viw1.pl > viw.htm 

ftp -n -v 167.10.6.50 <<EOF
user  oracle ******
ascii
put viw.htm dojv/viw.htm
quit
EOF