Toad World® Forums

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.


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

1 Like