Hi all,
I need a method to do the following process. a) I am populting a table in my database (which is on Oracle 9.0 on RHEL) using a.DAT file. This .DAT file is received by an FTP on my server and a scheduler program starts populating my table as soon as the file is received.
b) One process on SERVER A FTPes the .DAT file on SERVER B. As soon as the FTP Process creates an image of the file on the destination server B, the process of server B is triggered while the FTP is taking place.
c) Since the correct number of records are not recieved in the file in SERVER B the process in SERVER B abandones itself and the table is not properly populated.
Is there a way in which i can find out (using a shell script) whether the .DAT file has been locked for FTP or not?
Kindly suggest a way out. Regards, Sneh.