Page 1 of 1
Error while loading data
Posted: Tue Aug 21, 2007 3:01 pm
by reddy12
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.
Posted: Tue Aug 21, 2007 3:40 pm
by ArndW
And what does the Oracle error log file contain? That will tell you exactly what happened.
Re: Error while loading data
Posted: Tue Aug 21, 2007 3:44 pm
by kris
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.
Were you able to see the log file "ora.921628.154959.1.log" contents?
You should see what caused it.
Best ragards,
Posted: Tue Aug 21, 2007 7:49 pm
by reddy12
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. ...
Posted: Tue Aug 21, 2007 8:57 pm
by ArndW
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.
Posted: Tue Aug 21, 2007 9:10 pm
by Yuan_Edward
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. ...
Posted: Tue Aug 21, 2007 10:29 pm
by bkumar103
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