If SQL*Loader had not loaded all the stuff, then the first count(*) would return the same thing as the second one. My (wild) guess would rather be some mishandling of the high-water mark or something similar. Really looks like a bug. Things I would try : - Analyzing the table (compute) after the load, to check what Oracle finds - Checking the number of extents, etc. If the missing rows happen to be in a separate extent, does recreating the table in a big enough initial extent (heresy!) change anything ? - SQL*Loader, count(*), deallocate unused, count(*) - Playing with the various SQL*Loader option (INSERT/TRUNCATE/APPEND (in an emptied table) to see whether it makes a difference.
HTH, Stephane Faroult >----- Original Message ----- >From: "Ruth Gramolini" <[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L ><[EMAIL PROTECTED]> >Sent: Tue, 28 Jan 2003 07:54:35 > >Case of the Missing RowsCould they be in the .bad >file? I have had stuff go there if a column was >too long or something. > >Ruth > ----- Original Message ----- > From: Tim Gorman > To: Multiple recipients of list ORACLE-L > Sent: Monday, January 27, 2003 7:43 PM > Subject: Re: Case of the Missing Rows > > > My guess is that SQL*Loader didn't really load >88,640 rows, but rejected or discarded about 1400 >of them? > > ----- Original Message ----- > From: Weiss, Rick > To: Multiple recipients of list ORACLE-L > Sent: Monday, January 27, 2003 4:53 PM > Subject: Case of the Missing Rows > > > I have a recurring, repeatable problem I was >wondering about its cause. > > Oracle 9.2.0.1 on W2K Professional (SP2) Dell >Optiplex workstation Pentium 4 > > Step 1 - I do an SQLLDR process that loads >88640 rows to a table > Step 2 - SQL*Plus session - SELEC COUNT(*) from >the table returns 88640 rows > Step 3 - Do an EXP on the table (to allow fall >back to this point) - only exports 87257 rows > Step 4 - SQL*Plus session again - SELEC >COUNT(*) from the table returns 87257 rows > > No one else has access to the database. There >are no unusual entries in the alert log. > There is nothing I have found in the UDUMP or >BDUMP directories that would help. > > Has anyone else experienced this?? > > Thanks > > Rick Weiss > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroul INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).
