See Oracle Support Notes 1922923.1 and 2039794.1
The CREATE TABLE text is truncated in V$SQL itself to begin with.
Hemant K Chitale
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On ;
Behalf Of anthony Sanchez
Sent: Thursday, March 10, 2016 3:12 AM
To: oracle-l
Subject: ORA-00972, statement truncated in 10046 trace file
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
This email and any attachments are confidential and may also be privileged. If
you are not the intended recipient, please delete all copies and notify the
sender immediately. You may wish to refer to the incorporation details of
Standard Chartered PLC, Standard Chartered Bank and their subsidiaries at
https://www.sc.com/en/incorporation-details.html