Oracle-L: Re: Case of the Missing Rows

From: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
Date: Tue, 28 Jan 2003 07:54:36 -0800
Message-ID: <F001.0053C1CB.20030128075436@fatcity.com>

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: Ruth Gramolini
INET: rgramolini_at_tax.state.vt.us

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). Received on Tue Jan 28 2003 - 09:54:36 CST