SQLLDR - Don't Skip

From: Melih Onvural <melih.onvural_at_gmail.com>
Date: 25 Jul 2005 13:30:54 -0700
Message-ID: <1122323454.170233.275590@z14g2000cwz.googlegroups.com>

Group,

Here is my code:

select created, '^', event, '^', process_id from fmc.audit_trail where created > {lastDate};

that gets put into a CSV file and then it gets uploaded using the following control file:

LOAD DATA APPEND INTO TABLE
audit_trail
FIELDS TERMINATED BY '^' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS(

	CREATED,
	EVENT,
	PROCESS_ID,
	CREATED_DT "TO_DATE(SUBSTR(:created,1,19),'YYYY-MM-DD-HH24.MI.SS')")

However, it always skips over process_id and I can't figure out why. I appreciate any direction. I'm on Oracle 9.1 on a Linux system. Thanks for your help,

Melih Onvural Received on Mon Jul 25 2005 - 15:30:54 CDT