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 .
writing from oracle view to a oracle table?
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 19
- Joined: Fri Oct 15, 2010 1:26 pm
writing from oracle view to a oracle table?
suman Datastage Developer
-
- Premium Member
- Posts: 79
- Joined: Thu Mar 22, 2007 4:58 pm
- Location: USA
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.
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.
Jack Thornton
----------------
Spectacular achievement is always preceded by spectacular preparation - Robert H. Schuller
----------------
Spectacular achievement is always preceded by spectacular preparation - Robert H. Schuller
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: