Re: Newbie control file question
From: joel garry <joel-garry_at_home.com>
Date: Tue, 1 Sep 2009 09:24:30 -0700 (PDT)
Message-ID: <539cadcd-c90b-479f-9748-07050fe50ff0_at_f18g2000prf.googlegroups.com>
On Sep 1, 8:46 am, Sashi <small..._at_gmail.com> wrote:
> All, I'm trying to load data using a control file.
> Here's the sqlldr version:
> SQL*Loader: Release 10.2.0.3.0 - Production on Tue Sep 1 11:43:14 2009
>
> Copyright (c) 1982, 2005, Oracle. All rights reserved.
>
> Here's a sample data line:
> "941 -
> Warren","06/08/09","00:08","9085635152","9733928015","4","54","002","NEWARK ,
> NJ","NJ","Toll",".18","0000019619"
>
> Here's my control file:
>
> LOAD DATA
> INFILE '/my/source/file.csv'
> INTO TABLE dest_table
> FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS
> (
> SWITCH_NAME,
> CONNECT_DATE "MM/DD/YY",
> CONNECT_TIME,
> SRC_NUMBER,
> DEST_NUMBER,
> DUR_MM,
> DUR_SS,
> TRUNK,
> LOCATION,
> STATE,
> CALL_TYPE,
> COST,
> EXP_CODE
> )
>
> It's being rejected thus:
> Record 1: Rejected - Error on table CDR_TEMP_FEED, column
> CONNECT_DATE.
>
> How do I fix this?
>
> TIA,
> Sashi
Date: Tue, 1 Sep 2009 09:24:30 -0700 (PDT)
Message-ID: <539cadcd-c90b-479f-9748-07050fe50ff0_at_f18g2000prf.googlegroups.com>
On Sep 1, 8:46 am, Sashi <small..._at_gmail.com> wrote:
> All, I'm trying to load data using a control file.
> Here's the sqlldr version:
> SQL*Loader: Release 10.2.0.3.0 - Production on Tue Sep 1 11:43:14 2009
>
> Copyright (c) 1982, 2005, Oracle. All rights reserved.
>
> Here's a sample data line:
> "941 -
> Warren","06/08/09","00:08","9085635152","9733928015","4","54","002","NEWARK ,
> NJ","NJ","Toll",".18","0000019619"
>
> Here's my control file:
>
> LOAD DATA
> INFILE '/my/source/file.csv'
> INTO TABLE dest_table
> FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS
> (
> SWITCH_NAME,
> CONNECT_DATE "MM/DD/YY",
> CONNECT_TIME,
> SRC_NUMBER,
> DEST_NUMBER,
> DUR_MM,
> DUR_SS,
> TRUNK,
> LOCATION,
> STATE,
> CALL_TYPE,
> COST,
> EXP_CODE
> )
>
> It's being rejected thus:
> Record 1: Rejected - Error on table CDR_TEMP_FEED, column
> CONNECT_DATE.
>
> How do I fix this?
>
> TIA,
> Sashi
Perhaps you need to specify a keyword to tell the loader what kind of
field it is?
CONNECT_DATE DATE "MM/DD/YY",
See for example the controlfile demo at http://www.psoug.org/reference/sqlloader.html
jg
-- _at_home.com is bogus. http://www3.signonsandiego.com/stories/2009/aug/30/busted-card-cheating-ring-found-success-simplicity/?uniontribReceived on Tue Sep 01 2009 - 11:24:30 CDT