Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> sqlldr exit codes
I'm running SQL*Loader: Release 9.0.1.1.1 against Oracle9i Enterprise
Edition Release 9.2.0.3.0.
The client is on Windows 2000, Server is Solaris.
The issue is the sqlldr exit code from a direct path load.
sqlldr parameters are...
errors=0,direct=true,rows=5000,readsize=1000000
Indexes are not dropped. All rows are loaded ok.
When sqlldr hits a duplicate while rebuilding a unique index, it quits but exits with a zero exit code.
How can this not be considered a fatal error with a non-zero exit???!
Are there any workarounds to force a non-zero exit.
Yes, if there are enough records to use direct path, the indexes should probably be dropped and rebuilt, but the previous occupant didn't do it this way.
Thanks,
Gene H.
Received on Thu Feb 17 2005 - 08:35:22 CST