Rick,
Might there be a Scheduled Task or DBMS_Job that runs shortly after the
load and deletes rows?
Just a thought - such "automagic" processes have bitten me in the past.
Jack C. Applewhite
Database Administrator
Austin Independent School District
Austin, Texas
512.414.9715 (wk)
512.935.5929 (pager)
[EMAIL PROTECTED]
"Weiss, Rick"
<[EMAIL PROTECTED] To: Multiple recipients of list
ORACLE-L
us> <[EMAIL PROTECTED]>
Sent by: cc:
[EMAIL PROTECTED] Subject: Case of the Missing Rows
01/27/2003 05:53
PM
Please respond to
ORACLE-L
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:
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).
