Hi ALL,
I am using "direct path" method of SQL *Loader. I am
testing for a data file of 10000 records. Here when I
test at onsite there was one bad file generated with 1
bad record. My log file showed 9999 rows loaded
properly and 1 record not loaded due to data errors.
When I check the count of the rows loaded into the
table, it gives me a count of 9999. So except for the
1 bad record all the rows are committed in the
database.
But when my colleagues ran the same file using the
same control file at the client site, the log file
showed 9999 rows loaded properly and 1 record not
loaded due to data errors, but when I checked the
count from the table, the count was 0. None of the
rows were committed becuase of the 1 rejected record.
Why does this happen ? Why are the rows not committed
as it should have been as the SQl loader commits at
the end of the loading.
Is this beacuse of any setting in the parameter file
or any other parameters missing in the control file of
the SQL loader.
Your urgent help will be really help helpful
Thanks and Regards
________________________________________________________________________
For Stock Quotes, Finance News, Insurance, Tax Planners, Mutual Funds...
Visit http://in.finance.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Techy=20Guy?=
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).
