Brett,
If you have bad records, it should be reflected in the log but you can
also specify BAD for rejected records.
Also try to increase readsize and bindsize. Maybe you have an unusaully
long row.
Marina
Van den Bosch Bart wrote:
> Brett
>
> How many errors do you allow? If you don't accept any error, maybe this
> record is the first with an error and loader stops.
> Try to delete this record and see what happens.
>
> Bart Van den Bosch
>
> -----Original Message-----
> From: Brett Exton
> [mailto:oracledba-ezmlmshield-x52720923.[Email address protected]
> Sent: donderdag 29 mei 2008 17:29
> To: LazyDBA Discussion
> Subject: SQLLDR
>
> I am attempting to load several thousand rows into a table. Whilst the
> load doesn't fail and doesn't report any errors it always stops on the
> same row (876).
>
> I have checked there is nothing wrong with this row and have even over
> typed it, inserted an additional row and deleted this row but it always
> stops on 876
>
> I am assuming there is a buffer or max rows limit...if so can somebody
> enlighten me!
>
> Cheers!
>
> --
> Brett Exton
>
>
> ________________________________
> Please do not print this email unless absolutely necessary.
> Peidiwch ag argraffu'r neges e-bost hon oni bai fod hynny'n gwbl
> angenrheidiol.
>
> ________________________________________________________________________
> This e-mail and any attachments transmitted with it represents the
> views of the individual(s) who sent them and should not be regarded
> as the official view of Bridgend County Borough Council. The contents
> are confidential and intended solely for the use of the addressee. If
> you have received it in error, please inform the system administrator
> on (+44) 01656 642111.
>
> This e-mail and any attachments have been scanned with 'MessageLabs
> SkyScan' - http://www.messagelabs.com/
>
> ________________________________________________________________________
> Mae'r e-bost hwn ac unrhyw atodiadau a drosglwyddir gydag ef yn
> cynrychioli safbwyntiau'r unigolyn a'i anfonodd (unigolion a'u
> hanfonodd) ac ni ddylid eu hystyried fel safbwynt swyddogol Cyngor
> Bwrdeistref Sirol Pen-y-bont ar Ogwr. Mae'r cynnwys yn gyfrinachol ac
> wedi'i fwriadu ar gyfer y sawl y'i cyfeiriwyd ato yn unig. Os ydych
> wedi ei dderbyn mewn camgymeriad, rhowch wybod i weinyddwr y system ar
> (+44) 01656 642111.
>
> Mae'r e-bost hwn ac unrhyw atodiadau wedi cael eu sganio gyda
> 'MessageLabs SkyScan' - http://www.messagelabs.com/
> ________________________________________________________________________
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
> ______________________________________________________________________
>
> This e-mail and all files transmitted as attachment(s) thereto are confidential and solely intended for the individual to whom or the organization to which they are addressed.
>
> If you received this e-mail by mistake, please notify Cegeka’s system manager at [Email address protected] or call +32 (0)11 240 363. We thank you in advance.
>
> Cegeka hereby confirms that this message has been swept by Sophos for the presence of viruses.
> ______________________________________________________________________
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>

Oracle LazyDBA home page