SQL* Loader

From: Zvika Glickman <zglickman_at_il.bphx.com>
Date: 31 Mar 2004 07:38:24 -0800
Message-ID: <b6b91e64.0403310738.29f2a31f_at_posting.google.com>

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)

Received on Wed Mar 31 2004 - 17:38:24 CEST