help with batch operation

From: Eugene Pipko <eugene.pipko_at_unionbay.com>
Date: Tue, 8 Sep 2009 14:45:25 -0700
Message-ID: <34DB87F47199374280ADFD2968CDBCFA88143B3FA3_at_MAIL01KT.seattlepacificindustries.com>

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.

Regards,

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

--
http://www.freelists.org/webpage/oracle-l

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