Oracle Server - SQLLDR

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

SQLLDR - Don't Skip

Melih Onvural

2005-07-25, 8:25 pm

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(:crea
ted,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

Sponsored Links