Hi,
When I am using Load option in Oracle Enterprise Stage I am getting the below error:
The error is coming like this:
Table_OUTPUT_LDR,9: The system(sqlldr load/*****@cnotl CONTROL=ora.1221018.874080.9.ctl LOG=ora.1221018.874080.9.log BAD=ora.1221018.874080.9.log.bad SILENT=header PARFILE=ora.1221018.874080.9.par) failed; see the log file for the Oracle specific message.his;
With upsert this error is not coming.
Regards,
Suman
Load Vs Upsert in Oracle Enterprise Stage
Moderators: chulett, rschirm, roy
And what does the "ora.1221018.874080.9.log" log file contain?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
You probably have it but can't find it. Sometimes "find" doesn't locate files the way it should. I can't remember where those files are created, but would think somewhere in the Oracle directory tree. You will need to search around a bit - perhaps look for "ora*.log" to locate the correct directory.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
There's been a couple of recent posts on the 'where' of these sqlldr files. I seem to recall them going into your scratch space unless a particular ORA environment variable is set - something like ORA_SQLLDR_FILE_LOC but I know that's not it.
Perhaps a search would turn it up unless someone recalls the answer.
Perhaps a search would turn it up unless someone recalls the answer.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers