shareef
shareef

Reputation: 9581

When i run a specific query i get , ORA-00604: error occurred at recursive SQL level 1 ORA-12899: value too large for column"PLAN_TABLE"."OBJECT_NAME"

Am using Oracle 12.1 c when i run specific query ( i cant show for security reason , and because its un related); i get exception

ORA-00604: error occurred at recursive SQL 
level 1 ORA-12899: value too large for column "SOME_SCHEMA"."PLAN_TABLE"."OBJECT_NAME"  
(actual: 38, maximum: 30)

I cant make it work , i will try revert last changes i did because it was working before.

BTW i was doing Explain and doing index optimizations

Any idea why! P.S i will keep trying

Upvotes: 0

Views: 2809

Answers (1)

shareef
shareef

Reputation: 9581

How i solved this:

When i was reverting and reviewing my last changes i was doing alters for adding indexes, and each time i try to run the query again to make sure it is working.

So when i reached a specific alter i noticed the name of the index is too long, so even if the index was created successfully, but the explain plan for select was failing not the select it self.

The solution:

I renamed the index to be shorter ( 30 maximum ) it worked

Change table/column/index names size in oracle 11g or 12c

Why are Oracle table/column/index names limited to 30 characters?

Using EXPLAIN PLAN Oracle websites docs

check here summary

Upvotes: 1

Related Questions