('binary' encoding is not supported, stored as-is)
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" <rgramolini_at_tax.state.vt.us>
>To: Multiple recipients of list ORACLE-L
><ORACLE-L_at_fatcity.com>
>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: sfaroult_at_oriolecorp.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).
Received on Tue Jan 28 2003 - 11:13:58 CST
