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 <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED]> >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:[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
