8.1.7/Win2000

While loading a table with small tiff images (6k - 15K, out of line
Blob) and supporting data using SQL*loader we experienced a problem
that some of the images getting loaded aren't matching up with the
supporting data.  Row 95 has the images from Row 1985, etc.  Appears to
be random problem.  Some images are correct, others are not.  

Got rid of the readsize and bindsize and let them default and a test
load of 5000 images looked like everything loaded OK.  Now testing full
load of 200,000 to see if that fixes the problem.  Went from commit
point of 5000 records down to 23 now that the read and bindsize are
defaulting.

Any ideas as to why this might be happening?  I'm offsite and working
with them over the phone but will be heading in tonight so any ideas or
thoughts you have I can try out tonight.

Thanks - Brian



__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Brian Wisniewski
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Reply via email to