Where are Oracle bulk loader logs?

[mekrreddy]

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.

Thanks in advance.

[chulett]

The .log and .bad files are created in your "scratch" space defined by the config file in use at the time the job was run.

[mekrreddy]

Thanks hullet

I found the log and control file, it says all the rows are successfully loaded, 0 rejected, in that case why this fatal error?

thanks..

[chulett]

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?

[mekrreddy]

hullet,

index XXXXXX was made unusable due to SKIP_INDEX_MAINTANANCE optio requested.
does not say anything about else about indexes,

any other issue.??

[chulett]

No, isn't that enough?

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.

[ray.wurlod]

...load into an ORCLE table ...

The database from Lord of the Rings. _