using SQL*LOADER, loading many tables from one control (ctl) file
From: Zvika Glickman <zglickman_at_il.bphx.com>
Date: 1 Apr 2004 00:39:33 -0800
Message-ID: <b6b91e64.0404010039.27389a9a_at_posting.google.com>
[Quoted] 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.
Date: 1 Apr 2004 00:39:33 -0800
Message-ID: <b6b91e64.0404010039.27389a9a_at_posting.google.com>
[Quoted] 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_at_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)