I think you are missing TRAILING NULLCOLS clause
The TRAILING NULLCOLS clause tells SQL*Loader to treat any relatively
positioned columns that are not present in the record as null columns:
There may data missed in flatfile for few columns.
Thanks
-Ashish
----- Original Message -----
From: "Jautse Thabo "
<oracledba-ezmlmshield-x10803911.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Thursday, October 21, 2004 12:23 PM
Subject: SQLLDR Error
> Hi Gurus,
>
> When inserting records into a table I get the error below:
>
> "Record 1: Rejected - Error on table CIS_INFO, column
> X42239_ATAB_ACCOUNT4.
> Field in data file exceeds maximum length"
>
> I have increased that field to 1000 characters and I am certain that it
> isn't the
> problem. Where could I be going wrong with it?
>
> Regards,
>
> Thabo
> Oracle DBA
>
>
____________________________________________________________________________
_______________________
>
>
> The views expressed in this email are, unless otherwise stated, those of
the author and not those
> of the FirstRand Banking Group an Authorised Financial Service Provider or
its management.
> The information in this e-mail is confidential and is intended solely for
the addressee.
> Access to this e-mail by anyone else is unauthorised.
> If you are not the intended recipient, any disclosure, copying,
distribution or any action taken or
> omitted in reliance on this, is prohibited and may be unlawful.
> Whilst all reasonable steps are taken to ensure the accuracy and integrity
of information and data
> transmitted electronically and to preserve the confidentiality thereof, no
liability or
> responsibility whatsoever is accepted if information or data is, for
whatever reason, corrupted
> or does not reach its intended destination.
>
> ________________________________
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
terms:http://www.lazydba.com/legal.html
>
>
Oracle LazyDBA home page