Retrieve SQLCODE in Oracle Loader

[diogo.cwb]

Anybody know how can i retrieve th SQLCODE when i using an Oracle loader ?

Because i must load one table who i know have indexes but i'm loading with OPTIONS(DIRECT=TRUE,PARALLEL=TRUE,ERRORS=0,SKIP_INDEX_MAINTENANCE=TRUE) and in production enviroment i get the below error:

Time : Fri Jul 10 10:27:10 2009
Type : FATAL
User : maecgf
Message :
FCT_FINANCEIRA,0: The system(sqlldr cgfown10@orapr5p7 CONTROL=ora.29728956.787846.0.ctl LOG=ora.29728956.787846.0.log
BAD=ora.29728956.787846.0.log.bad SILENT=header PARFILE=ora.29728956.787846.0.par) failed; see the log file for the Oracle specific message.

i already read the log file and we only have the below message...because the load was done right...but my job return FATAL error...

The following index(es) on table FCT_FINANCEIRA were processed:
index CGFOWN10.CGF080IX01_ partition P_380 was made unusable due to:
SKIP_INDEX_MAINTENANCE option requested

[mansoor_nb]

You need to include "SKIP_UNUSABLE_INDEXES" in the Oracle Load Options like
"DIRECT=TRUE, SKIP_INDEX_MAINTENANCE=YES, SKIP_UNUSABLE_INDEXES=NO"
or
"DIRECT=TRUE, SKIP_INDEX_MAINTENANCE=TRUE, SKIP_UNUSABLE_INDEXES=FALSE"

Then the skip_index_maintenance will prevail, no matter what the originalstatus of the index is.

[devanars]

I am also not able to insert records in the target table with any of these options. can we get any suggestions from anybody.

Thaks

[chulett]

Again, please do not hijack other people's posts - start your own.