Date: Wed, 16 Sep 2009 09:28:09 +0200
> Looks like a decent solution, I'll try it. However, I am assuming
> that there are spaces between some of these parameters?
> echo -e "$RAPORT_TYPE\n1 $MIN_SNAP $MAX_SNAP\n $RAPORT_NAME\n"
works for me, without spaces:
echo -e "$RAPORT_TYPE\n1$MIN_SNAP$MAX_SNAP\n$RAPORT_NAME\n"|(sqlplus -S "/ as sysdba" _at_$ORACLE_HOME/rdbms/admin/awrrpt.sql) >> $LOG_DIR/log.txt
are you using bash ? i'm not sure if it's working in other shells
cheers Received on Wed Sep 16 2009 - 02:28:09 CDT