I think what you are looking for is

if [ ! -s $LOCAL_FILE ]; then
...
fi

On Fri, 2003-08-29 at 13:28, Renee Roy wrote:
> Hi! I need some help with the following code as I have little
> experience with Korn Shell.
>
> This is part of an auto refresh script for our test databases that
> checks for a copy of the production dmp file and then imports it and
> makes other changes to the test db. If the export from production
> fails, and the dmp file size is 0, adding this code will cause the job
> will to stop. However if the file is OK and has the usual still run,
> but there is not data. If the file is the usual 3.7 G of data, if
> will also now fail. Any suggestions as to how to code this so it will
> not run if the file is empty, and run if the file is OK?
>
> If I remove the '!' from the -s then the script runs if the file is 0
> and if it is OK.
>
>
> #
> # Do not process if file size = 0 bytes.
> #
> if ! [ -s $LOCAL_FILE ]
> then
> echo " <$LOCAL_FILE> Not processed because file size=0 bytes." >>
> $LOGFILE
> Scr_Exit 0
> fi
>
>
> (NT 4.0, Oracle 7.3.4.5.2, we use Korn Shell scripts through Telnet
> sessions)
>
> Thanks, Renee
>
>
> AFSC is now online, please visit: www.afsc.ca <http://www.afsc.ca>
>
> This communication is intended for the use of the recipient to which
> it is addressed, and may contain confidential, personal and/or
> privileged information. Please contact us immediately if you are not
> the intended recipient of this communication, and do not copy,
> distribute, or take action relying on it. Any communication received
> in error, or subsequent reply, should be deleted or destroyed.
>
>
>
--
Richard Quintin, DBA
Information Systems & Computing, DBMS
Virginia Tech

Oracle LazyDBA home page