using SQL*LOADER, loading many tables from one control (ctl) file

[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)

[Daniel Morgan]

Zvika Glickman wrote: 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)

You will find an example of how to do it here:
http://www.psoug.org/reference/sqlloader.html
look at demo9

--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)