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
Retrieve SQLCODE in Oracle Loader
Moderators: chulett, rschirm, roy
Retrieve SQLCODE in Oracle Loader
Diogo de Oliveira Vasconcellos
diogo.cwb@gmail.com
diogo.cwb@gmail.com
-
- Participant
- Posts: 48
- Joined: Wed Jun 01, 2005 7:10 am
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.
"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.