Bret,
There is a lot of internet info re: sqlldr
I finally bought a book=
Oracle SQL*Loader- O'reilly Publishing
you can set errors on the same line you call out your control file:
ie. sqlldr sys/support ctrl=bigtable.ctl errors=100000
see if that helps-
sqlldr is the most underated sql tool out there-
I loaded 350,000 records in about 1.5 minutes.
Good to know, MSSQL has nothing even close to efficiency
or debugging.
Good luck
Jim T
-----Original Message-----
From: Brett Exton
[mailto:oracledba-ezmlmshield-x52720923.[Email address protected]
Sent: Thursday, May 29, 2008 11:29 AM
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
Oracle LazyDBA home page