Generic scripts to sftp files: https://vollett.net/wp-content/uploads/2018/10/sftp.zip sftp.zip contains: 1) sftp_batch_job.sh: Wrapper script that reads GHAW_IIS_001 file and for each line within calls… 2) sftp_files.sh: Issues SFTP commands 3) GHAW_IIS_001: List of SFTP instructions that make up the batch job
To obtain a lock on a file, use flock command as per example:
set serveroutput on; alter session enable parallel dml; –NB: not possible within partition or on non-partitioned table for delete/update/merge operations alter session set nls_date_format=’yyyy-mm-dd hh24:mi:ss’; select sysdate as script_start from dual; <STUFF> select to_char(sysdate, ‘YYYY/MM/DD HH:mi:ss’) as script_end from dual;