MS DOS Batch file - Running Oracle Processes, Executes too quickly & does not Redirect Output
Posted on 2002-04-04
I'm using a batch file to execute several steps in updating a database:
Step 1 - Trucates the tables in Oracle
Step 2 - Loads new infor into the tables
Step 3 - Updates info
Ect, Ect - eventually there will be 5 steps
For now I am just trying to accomplish the first 2 steps
My Batch file code looks like this:
start WAIT/C:\ORANT\Bin\Plus80W.exe Userid/pw@db @C:\Testing\sql.TXT>C:\Log.txt
START WAIT/C:\ORANT\Bin\sqlldr80.exe parfile=C:\Test.par>>C:\Log.txt
I have a 2 part problem:
Step 2 executes before step 1 finishes truncating the tables - HOW DO I CORRECT THIS?
***If I run each of these from the command line - all of both steps output shows up in LOG.txt,
When I seperate into 2 batch files and run seperately I get only the output from step 1.
Or if I just run step 2 as a seperate batch file then Log.txt is blank.
Need to be able to have all output in one log.