Whoops! Sorry about that... ...grumble...over-40 eyes.....over-40 brain......grumble...mutter........
----- Original Message ----- To: <[EMAIL PROTECTED]>; "Tim Gorman" <[EMAIL PROTECTED]> Sent: Monday, January 27, 2003 11:27 PM > > If that were the case, he would not have seen 88640 rows > from sqlplus, as he reported. > > Jared > > On Monday 27 January 2003 16:43, Tim Gorman wrote: > > Case of the Missing RowsMy 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 > > ---------------------------------------- > Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1" > Content-Transfer-Encoding: quoted-printable > Content-Description: > ---------------------------------------- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman 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).
