Oracle Error
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 95
- Joined: Thu Sep 24, 2009 12:15 am
- Location: India
Oracle Error
Hi All,
I don't know what to do to remove this Fatal Error:
Oracle_Enterprise_3,1: The system(sqlldr CONTROL=ora.2714.131128.1.ctl LOG=ora.2714.131128.1.log BAD=ora.2714.131128.1.log.bad SILENT=header PARFILE=ora.2714.131128.1.par) failed; see the log file for the Oracle specific message.
Only few of the records are getting inserted into the target table.
Any solution?
Thanks in advance.
-Deepa
I don't know what to do to remove this Fatal Error:
Oracle_Enterprise_3,1: The system(sqlldr CONTROL=ora.2714.131128.1.ctl LOG=ora.2714.131128.1.log BAD=ora.2714.131128.1.log.bad SILENT=header PARFILE=ora.2714.131128.1.par) failed; see the log file for the Oracle specific message.
Only few of the records are getting inserted into the target table.
Any solution?
Thanks in advance.
-Deepa
-
- Premium Member
- Posts: 54
- Joined: Thu Oct 18, 2007 4:20 am
- Location: Chennai
-
- Participant
- Posts: 95
- Joined: Thu Sep 24, 2009 12:15 am
- Location: India
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: Oracle Error
deepa_shenoy wrote:see the log file for the Oracle specific message.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 95
- Joined: Thu Sep 24, 2009 12:15 am
- Location: India
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
Why you need root priviledge to find and see a file?If you have root access on Unix machine (u could try with your login), a simple find command would help you locate the file.
You just have to look in to your cofiguration file (which is present in log itself) to see which location is being used for Scratch and the file will be there.
ora.2714.131128.1.log file will have reason why the record got rejected or discarded.
An to see the data discarded look in to ora.2714.131128.1.log.bad file.
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.
Genius may have its limitations, but stupidity is not thus handicapped.
Locating a file through a FIND command is easier with ROOT login as it does not give you error on Directories that you don't have access to, while searching the file with your user login.priyadarshikunal wrote:Why you need root priviledge to find and see a file?
Comment was more specific on searching and locating the file.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Code: Select all
find [ options ] 2>/dev/null
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: