help with batch operation
- From: Eugene Pipko <eugene.pipko@xxxxxxxxxxxx>
- To: 'Oracle L' <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 8 Sep 2009 14:45:25 -0700
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.
Other related posts:
