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
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
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
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]
(51
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