Hi All,

i am running a oracle procedure which writes a file . The same file is picked up by another script which runs in a cron after every 5 minutes.

Now the problem is that sometimes my script picks up a file while the procedure is still writing data in the file.

is there is any way i can lock my file, so that no other process process a file while one is still processin the file.

Thanx in advance

Saurabh

Hi,
No, I don't believe you can lock a file to prevent another process trying to copy it.
You can do an fuser on the file though to see if it is still being used or written to before you pick it up though.
Andy