I am getting the following error when trying to load into an ORCLE table
using Load and Append,
job_0001,0:The system(sqlldr CONTROL=ora.1306720.90647.0.log
BAD=ora.1306720.90647.0.log.bad SILENT=header PARFILE= ora.1306720.90647.0.par) failed: see the log file for oracle specific message.
To view the logfile mentioned in the error i dont know the location of the file..
I see this kind of errors in this forum but does not have any solution, please help me out.
All loaded and zero rejected doesn't mean everything was fine. Keep reading, are there any ORA errors mentioned after that? Duplicates in a unique index, perhaps?
-craig
"You can never have too many knives" -- Logan Nine Fingers
That's your fatal and you have an UNUSABLE index on your table now. Talk to your DBA about how to fix that. And see about not skipping "index maintenance" for any future loads.
-craig
"You can never have too many knives" -- Logan Nine Fingers