Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Case of the Missing Rows
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
My guess is that SQL*Loader didn't really load 88,640 rows, but rejected or discarded about 1400 of them?
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: Weiss, Rick
INET: rweiss_at_state.mt.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 - 10:24:26 CST