Hi i am geting the follwoing error.Just i am loading the data from flat file to oracle table.
Oracle_Enterprise_19,1: The system(sqlldr shrhlth/shared1@orcdbt CONTROL=ora.921628.154959.1.ctl LOG=ora.921628.154959.1.log BAD=ora.921628.154959.1.log.bad SILENT=header PARFILE=ora.921628.154959.1.par) failed; see the log file for the Oracle specific message.
can you please any one have Idea about this?
Thanks.
Error while loading data
Moderators: chulett, rschirm, roy
And what does the Oracle error log file contain? That will tell you exactly what happened.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Re: Error while loading data
Were you able to see the log file "ora.921628.154959.1.log" contents?reddy12 wrote:Oracle_Enterprise_19,1: The system(sqlldr shrhlth/shared1@orcdbt CONTROL=ora.921628.154959.1.ctl LOG=ora.921628.154959.1.log BAD=ora.921628.154959.1.log.bad SILENT=header PARFILE=ora.921628.154959.1.par) failed; see the log file for the Oracle specific message.
You should see what caused it.
Best ragards,
~Kris
I can't recall where the location defaults to, it will be either in the project directory or under the Oracle dir. I'd simply use the UNIX find command to locate it.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 73
- Joined: Tue May 10, 2005 6:21 pm
- Location: Sydney
Check the APT configuration file of your job and the scratch disk should be the location for Oracle sqlldr logs.
reddy12 wrote:Thanks for your reply
I don't know where can i find this oracle log..
Please let me know if you have any idea..
Thanks.
ArndW wrote:And what does the Oracle error log file contain? That will tell you exactly what happened. ...
Edward Yuan
Hi
Oracle log file will be created in the directory, where the control file is placed. It will be good practice instead of just specifying the log file name give the compete path for the log file where it can be stored.
like
sqlldr shrhlth/shared1@orcdbt CONTROL=ora.921628.154959.1.ctl LOG=<log file dir>/ora.921628.154959.1.log BAD=<bad file dir>/ora.921628.154959.1.log.bad SILENT=header PARFILE=ora.921628.154959.1.par
Oracle log file will be created in the directory, where the control file is placed. It will be good practice instead of just specifying the log file name give the compete path for the log file where it can be stored.
like
sqlldr shrhlth/shared1@orcdbt CONTROL=ora.921628.154959.1.ctl LOG=<log file dir>/ora.921628.154959.1.log BAD=<bad file dir>/ora.921628.154959.1.log.bad SILENT=header PARFILE=ora.921628.154959.1.par