Re: How do I get column name that causing ORA-01438
- From: "Syed Jaffar Hussain" <sjaffarhussain@xxxxxxxxx>
- To: "Mladen Gogala" <mgogala@xxxxxxxxxxx>
- Date: Wed, 21 Feb 2007 23:32:41 +0300
Mladen,
Yes, I do set the event to trace the culprit. The problem is that when I
enable this event, Oracle is taking around 6 second to return the error msg.
on the sql prompt. And ours is a very high OLTP application where around 500
tps take places.
We have request Oracle for an enhancement. Because, when constraints
violates, Oracle do gives the constrain name and details, likewise, I would
like to have so and so column in the particular table is the culprit.
Regards
Jaffar
On 2/21/07, Mladen Gogala <mgogala@xxxxxxxxxxx> wrote:
Syed Jaffar Hussain wrote:
> Hi List,
>
> Is there a way though which I can found out the column name causing an
> ORA-01438?
> I tried tracing the session, unfortunately, the trace file doesn't
> have any cluses about the column causing this error.
> Any link or workaround is appreciated.
ALTER SESSION SET EVENTS='1438 TRACE NAME ERRORSTACK FOREVER, LEVEL 12';
--
Mladen Gogala
Sr. Oracle DBA
Video Monitoring Systems
1500 Broadway
New York City, NY 10036
Phone: (212) 329-5201
Email: mgogala@xxxxxxxxxxx
--
Best Regards,
Syed Jaffar Hussain
Oracle ACE
8i,9i & 10g OCP DBA
http://jaffardba.blogspot.com/
http://www.oracle.com/technology/community/oracle_ace/ace1.html#hussain
----------------------------------------------------------------------------------
"Winners don't do different things. They do things differently."
Other related posts:
