help with batch operation

From: Eugene Pipko <>
Date: Tue, 8 Sep 2009 14:45:25 -0700
Message-ID: <>

Hi all,
Running Oracle 9.2 on Windows.
I know this is Oracle forum, but it's somewhat related. This question is for those of you who run Oracle on Windows. I have several ".txt" files in a directory (all different names) and looking for the possibility to do the following using .BAT file:
  1. Take first file
  2. rename it
  3. run procedure (pass it in)
  4. move it into archive dir
  5. delete it from original dir
  6. GOTO 1
Reason I have to do all this is because in step 3 I am using external table to read the ".txt" file and it has to have a unique file name.


Eugene Pipko
Seattle Pacific Industries
office: 253.872.5243
cell: 206.304.7726
P Please consider the environment before printing this e-mail.

Received on Tue Sep 08 2009 - 16:45:25 CDT

Original text of this message