Well,
you can runt the sqllodader again and then include this line after the name ofthe control file. log = C:\temp\error.log and that creates a logfile where you can see what has happened. The problem you are having can be caused by invalid length of the datafield in the database, or you have tried to insert a nullvalue inthe database where there is a constraint. Hope this helps Roland Ken Janusz <[EMAIL PROTECTED]>@fatcity.com den 2001-12-03 13:33 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL PROTECTED] Till: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Kopia: I am working on a control script that I have restricted to only loading 5 records as a test. Basically I am taking data from the load file and putting it into a table SQL Loader runs and gives me this. --------------------------------------------- SQL*Loader: Release 8.1.7.0.0 - Production on Mon Dec 3 15:22:26 2001 (c) Copyright 2000 Oracle Corporation. All rights reserved. Commit point reached - logical record count 5 ---------------------------------------------- When I do a select on this table I get no rows selected. I don't get an error message from SQL Loader. So any ideas as to what the problem is? Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
