Re: Case of the Missing Rows

Whoops! Sorry about that...

...grumble...over-40 eyes.....over-40 brain......grumble...mutter........

• Original Message ----- To: <ORACLE-L_at_fatcity.com>; "Tim Gorman" <Tim_at_SageLogix.com> 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: Tim_at_SageLogix.com

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: ListGuru_at_fatcity.com (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).