TOAD_PLAN_TABLE Issue

Toad for Oracle
1

Hi Everyone!

I faced this error during the execution of explain plan

[Error] Explain Plan (71: 28): ORA-00604: error occurred at recursive SQL level 1
ORA-12899: value too large for column "TOAD_PLAN_TABLE"."OBJECT_NAME" (actual: 32, maximum: 30)

Toad for Oracle Base (64-bit)
16.3.231.2085

2

HI Denis,

It sounds like that table was created for an Oracle version less than 12, and now Oracle 12 or newer is using it. You can either drop the table and then Toad will prompt to recreate it, or you can just run this SQL to modify it:

ALTER TABLE TOAD_PLAN_TABLE
MODIFY(OBJECT_OWNER VARCHAR2(128),
       OBJECT_NAME VARCHAR2(128));
1 Like