Re: ORA-00972, statement truncated in 10046 trace file

Maybe there are other techniques, but one option might be to temporarily turn on net client tracing, or if you can't access the client, turn on server side tracing. When I used server side net tracing I haven't encountered any issues so far, but of course if doing that on a busy production database, I'd be cautious.

Turn on network tracing on client (or server by replacing "_CLIENT" with "_SERVER") by temporarily adding these lines to sqlnet.ora: TRACE_LEVEL_CLIENT = SUPPORT
TRACE_DIRECTORY_CLIENT=/tmp/client_traces DIAG_ADR_ENABLED=OFF Execute the failing statement from the client, e.g.: SQL> create table scott.testing_table_name_longer_than_allowed as select * from dual;
create table scott.testing_table_name_longer_than_allowed as select * from dual

                   *

Then check the generated trace file for "packet dump":

(792061696) [09-MAR-2016 21:19:03:866] nsbasic_bsd: packet dump
(792061696) [09-MAR-2016 21:19:03:866] nsbasic_bsd: 00 00 00 00 00 00 00
00 |........|
(792061696) [09-MAR-2016 21:19:03:866] nsbasic_bsd: 00 00 00 00 00 00 00
00 |........|
(792061696) [09-MAR-2016 21:19:03:866] nsbasic_bsd: 00 00 00 00 00 00 00
00 |........|
(792061696) [09-MAR-2016 21:19:03:866] nsbasic_bsd: 00 00 00 00 00 4F 63
72 |.....Ocr|
(792061696) [09-MAR-2016 21:19:03:866] nsbasic_bsd: 65 61 74 65 20 74 61
62 |eate.tab|
(792061696) [09-MAR-2016 21:19:03:866] nsbasic_bsd: 6C 65 20 73 63 6F 74
74 |le.scott|
(792061696) [09-MAR-2016 21:19:03:866] nsbasic_bsd: 2E 74 65 73 74 69 6E
67 |.testing|
(792061696) [09-MAR-2016 21:19:03:866] nsbasic_bsd: 5F 74 61 62 6C 65 5F
6E |_table_n|
(792061696) [09-MAR-2016 21:19:03:866] nsbasic_bsd: 61 6D 65 5F 6C 6F 6E
67 |ame_long|
(792061696) [09-MAR-2016 21:19:03:866] nsbasic_bsd: 65 72 5F 74 68 61 6E
5F |er_than_|
(792061696) [09-MAR-2016 21:19:03:866] nsbasic_bsd: 61 6C 6C 6F 77 65 64
20 |allowed.|
(792061696) [09-MAR-2016 21:19:03:866] nsbasic_bsd: 61 73 20 73 65 6C 65
63 |as.selec|
(792061696) [09-MAR-2016 21:19:03:866] nsbasic_bsd: 74 20 2A 20 66 72 6F
6D |t.*.from|
(792061696) [09-MAR-2016 21:19:03:866] nsbasic_bsd: 20 64 75 61 6C 01 00
00 |.dual...|

Hope it helps.

Regards,
Jure Bratina

--
http://www.freelists.org/webpage/oracle-l