Oracle 19.10 - Explain plan - ora-12899: value too large

When I click the explain plan button I get the error below. This is for Oracle 19.10 on Oracle Linux 7.8 x64. Please see the attached.

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

I dropped the table and recreated and now all is working. Please ignore.

1 Like

Hi Ed,

Just modify the TOAD_PLAN_TABLE.OBJECT_NAME and OBJECT_OWNER columns so they have a size of 128. I have verified that our source should create it that way if the database supports it, so I guess either an old version of Toad created that table, or the database was upgraded after the table was created.

-John

Looks like this was as you said just old. Thank you

1 Like