| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Loader commit problem
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
Regards
Visit http://in.finance.yahoo.com/
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: 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 Wed Dec 19 2001 - 06:17:01 CST
 |
 |