Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Case of the Missing Rows

RE: Case of the Missing Rows

From: Fink, Dan <>
Date: Tue, 28 Jan 2003 08:13:51 -0800
Message-ID: <>


    Another idea is to check the explain plans of each of the queries. If there is a difference it could indicate that the data is there, but a particular access path is invalid.  

Dan Fink

-----Original Message-----
Sent: Tuesday, January 28, 2003 7:45 AM
To: Multiple recipients of list ORACLE-L


    Try the following to see which rows are missing. It the same rows are missing each time, perhaps there is a common thread. If not, well....  

    After Step 2, do a create table as select or sql*plus copy. This will create a backup version. Do a count(*) from each to make sure the numbers agree.

    After Step 4, select * from table1 minus select * from backup_copy to locate the missing rows.  

Dan Fink

-----Original Message-----
Sent: Monday, January 27, 2003 4:54 PM
To: Multiple recipients of list ORACLE-L

I have a recurring, repeatable problem I was wondering about its cause.

Oracle 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??


Rick Weiss


Please see the official ORACLE-L FAQ:

Author: Fink, Dan

Fat City Network Services    -- 858-538-5051
San Diego, California        -- Mailing list and web hosting services
To REMOVE yourself from this mailing list, send an E-Mail message to: (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 - 10:13:51 CST

Original text of this message