Re: Case of the Missing Rows

Is the table in an autoallocate tablespace - is the tablespace using assm ?

Are the appropriate list of extents apparently present in the table. Can you dump the
segment header block to see if the extent list looks sensible. Is the tablespace free space consistent with the tablespace used space ?

Have you tried to run validate structure on the table, and the various dbms_space_admin
bitmap routines in the table and tablespace ?

Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Coming soon a new one-day tutorial:
Cost Based Optimisation
(see http://www.jlcomp.demon.co.uk/tutorial.html )

____UK_______March
____USA_(FL)_May

Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )

____USA_(CA, TX)_August

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

-----Original Message-----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Date: 28 January 2003 17:10

>Nope, .BAD file is empty, I have been experimenting this morning with
>cloning the table as suggested earlier, but every DDL statement
against the
>table drops the rows (#'s 70-1417) of the ID PK Column. Still working
on
>that angle
>
>Rick Weiss
>
>-----Original Message-----
>Sent: Tuesday, January 28, 2003 8:55 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Could they be in the .bad file? I have had stuff go there if a
column was
>too long or something.
>
>Ruth
>
>----- Original Message -----
>To: Multiple recipients of list ORACLE-L
<mailto:ORACLE-L_at_fatcity.com>
>Sent: Monday, January 27, 2003 7:43 PM
>
>My guess is that SQL*Loader didn't really load 88,640 rows, but
rejected or
>discarded about 1400 of them?
>
>
>----- Original Message -----
>To: Multiple recipients of list <mailto:ORACLE-L_at_fatcity.com>
ORACLE-L
>Sent: Monday, January 27, 2003 4:53 PM
>
>
>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: Jonathan Lewis
  INET: jonathan_at_jlcomp.demon.co.uk

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).