Home » RDBMS Server » Server Utilities » REPLACE in SQL Loader
REPLACE in SQL Loader [message #69582] Tue, 05 February 2002 06:39 Go to next message
Shantan
Messages: 2
Registered: February 2002
Junior Member
Hi,
I am trying to load data from a file into a temporary table using SQL Loader and REPLACE. But, the data from the file doesn't get loaded in the same order as it is in the file. I need to have the data loaded into the table in the same order as in the file because there are headers and matching lines for these records. This is the SQL Loader script I'm using:

LOAD DATA
INFILE '&1'

REPLACE
INTO TABLE zce_ukicitibank_temp
TRAILING NULLCOLS
(
FIELD1 CHAR TERMINATED BY "@",
FIELD2 CHAR TERMINATED BY "@",
FIELD3 CHAR TERMINATED BY "@",
FIELD4 CHAR TERMINATED BY "@",
FIELD5 CHAR TERMINATED BY "@",
FIELD6 CHAR TERMINATED BY "@",
FIELD7 CHAR TERMINATED BY "@",
FIELD8 CHAR TERMINATED BY "@",
FIELD9 CHAR TERMINATED BY "@",
FIELD10 CHAR TERMINATED BY "@",
FIELD11 CHAR TERMINATED BY "@",
FIELD12 CHAR TERMINATED BY "@",
FIELD13 CHAR TERMINATED BY "@",
FIELD14 CHAR TERMINATED BY "@",
FIELD15 CHAR TERMINATED BY "@",
FIELD16 CHAR TERMINATED BY "@",
FIELD17 CHAR TERMINATED BY "@",
FIELD18 CHAR TERMINATED BY "@",
FIELD19 CHAR TERMINATED BY "@",
FIELD20 CHAR TERMINATED BY "@"
)

Can anybody help me?

Thanks & Regards,
Shantan
Re: REPLACE in SQL Loader [message #69589 is a reply to message #69582] Tue, 05 February 2002 08:28 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
Have you seen this link?
http://www.orafaq.net/faqloadr.htm
Re: REPLACE in SQL Loader [message #69591 is a reply to message #69582] Tue, 05 February 2002 08:49 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
use rows=1 command line parameter
Previous Topic: Interpreting tkprof output
Next Topic: export & lock
Goto Forum:
  


Current Time: Fri Mar 29 08:29:38 CDT 2024