Ken
Did you look at the Sql*Loader log file?
Maybe all your records were rejected and placed into the .bad file? Does a
.bad file exist? Sql*Loader does not really consider rejected records an
error - it just moves them there.
Hope this helps.
Tom Mercadante
Oracle Certified Professional
I finally got it to work. The book is a great help, but you still need the
old trial and error method.
Thanks much for your help,
Ken
-Original Message-
Sent: Tuesday, December 04, 2001 7:35 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: SQL Loader Commit
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
Ken,
Check the Loader log file. The records are being rejected for some reason
and Loader only tells you in the log.
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
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
