ORA-00972, statement truncated in 10046 trace file

From: anthony Sanchez <anthonycsanchez_at_gmail.com>
Date: Wed, 09 Mar 2016 19:12:26 +0000
Message-ID: <CAEwv4fE0jhfO_mHgKpfMzeWTBnBMMCM73gY=dM34+p16t_OCUg_at_mail.gmail.com>



Hi folks,

I have an app throwing ORA-00972 during a create table statement. I assume the table name is over 30 characters, however I'd like to see what the name attempting to be used is for troubleshooting purposes.

The app is not returning error info that is that helpful, so I decided to setup a trace to get more info. While the trace did capture the error, the statement is being truncated/abbreviated in the trace file.

PARSE ERROR #863794672:len=2610 dep=0 uid=52 oct=1 lid=52 tim=1447938666502 err=972

CREATE TABLE STAGING.wdsC ...

WAIT #0: nam='SQL*Net break/reset to client' ela= 3 driver id=1413697536 break?=1 p3=0 obj#=-1 tim=1447938666574

WAIT #0: nam='SQL*Net break/reset to client' ela= 660 driver id=1413697536 break?=0 p3=0 obj#=-1 tim=1447938667252

WAIT #0: nam='SQL*Net message to client' ela= 2 driver id=1413697536
#bytes=1 p3=0 obj#=-1 tim=1447938667277

WAIT #0: nam='SQL*Net message from client' ela= 4757 driver id=1413697536
#bytes=1 p3=0 obj#=-1 tim=1447938672062

XCTEND rlbk=0, rd_only=1, tim=1447938672130

WAIT #0: nam='SQL*Net message to client' ela= 2 driver id=1413697536
#bytes=1 p3=0 obj#=-1 tim=1447938672181

WAIT #0: nam='SQL*Net message from client' ela= 660 driver id=1413697536
#bytes=1 p3=0 obj#=-1 tim=1447938672860

Any ideas on capturing the full statement?

Oracle 11.2.0.4 on windows.

Thank you,

Anthony

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Mar 09 2016 - 20:12:26 CET

Original text of this message