SQL* Loader

[Zvika Glickman]

DB: Oracle 9.2. Application: SQL*LOADER.
I have to load many tables.
I have just one ctl file that contains information on all the tables
(each table is different) and reference different data file for each
table.

I get syntax error when i start to define the second table in the ctl
file.

Is it allowed to do? How?

****** Control file start here ******
LOAD DATA
INFILE 'load_tst.dat'
INTO TABLE load_tst
TRUNCATE
( f1 POSITION(1:3),
f2 POSITION(4:6)
)
OPTIONS (SILENT=FEEDBACK,DIRECT=TRUE)
LOAD DATA
INFILE 'load_tst1.dat'
INTO TABLE load_tst1
TRUNCATE
( f1 POSITION(1:3),
f2 POSITION(4:6)
)
****** Control file finished here ******

** Error i get:
[vashti]<rotem> /users/arsi/zvika/rsi/tstload>sqlldr RSI/RSI@orasp
control=load_tst
SQL*Loader: Release 9.2.0.2.0 - Production on Wed Mar 31 15:12:58 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL*Loader-350: Syntax error at line 9.
Expecting keyword INTO, found keyword options.
OPTIONS (SILENT=FEEDBACK,DIRECT=TRUE)