DSXchange

Posted: **Tue May 31, 2011 11:40 am**

I am loading into a oracle table from a oracle view and i am getting the following wierd error.

TrgCcdbStgAcctWkSalePassThru,3: The system(sqlldr CONTROL=ora.3317770.688603.3.ctl LOG=ora.3317770.688603.3.log BAD=ora.3317770.688603.3.log.bad SILENT=header PARFILE=ora.3317770.688603.3.par) failed; see the log file for the Oracle specific message.

can any one please tell me how i need to trouble shoot this .

Posted: **Tue May 31, 2011 5:03 pm**

There will be a log directory in your system with the name 'ora.3317770.688603.3.log.bad' The location is dependent upon your system setup.

Find this file and look at it. It is a text file, so you can use your favorite editor (or just use 'cat' or 'more' or 'less') to view the contents and find the specific oracle error.

If the error does not make sense, use google or the oracle support site for more assistance.

Posted: **Tue May 31, 2011 5:21 pm**

Check on your scratchdisk for the "bad" file.

DSXchange

writing from oracle view to a oracle table?

writing from oracle view to a oracle table?