Hi, Can anyone help me on the error message ? recover.sh: line 18: syntax error: unexpected end of file ================================== #!/usr/bin/sh HostName=`hostname` LOGDIR=$PWDLE_SID LOGFILE=$LOGDIR/${MYSID} num=0 while [$num -lt 10] do echo -n $num num='expr $num+1' sqlplus /nolog <<EOF conn / as sysdba recover datafile $num; exit done echo "\n Done " Thanks & Regards, Vinod Sadanandan Oracle DBA Vinod Sadanandan Oracle DBA

Hi, an easy one: you have to close the phrase: sqlplus/nolog << EOF insert a new line with the text EOF, beginning at column 1, where the stacked commands for sqlplus end (I guess it's the line between "exit" and "done" cheers Wollie

Hi Wollie, Many thanks for the reply,will make things work :-) i had appended this into the above one. declare num INTEGER(5); begin num := 1; while num<=300 loop num := num+1; recover datafile num; exit when num > 300; end loop; end; / Vinod Sadanandan, Oracle DBA Public profile http://www.linkedin.com/pub/5/464/578

if [ -e $1 ] then cd $LOCAL sqlplus saftecno/saftecno <<EOF execute integracaoforcadevendas_tec.importarpedidopalm('$1'); exit EOF exit 1 fi when I run the below lines. Red Hat return's me the following message: /bin/pedidos: line 19: syntax error: unexpected end of file