Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
KommulaRahul
Contributor III

Oracle caller interface:ORA-00972 :identifier is too long

17141400610709169909731011208022.jpg

 What could be the reason for this

Any solution? 

Labels (1)
1 Reply
Vegar
MVP

It could be that a column name, table name, or alias exceeds the maximum length allowed by Oracle, which is 128 chars for version 12.2 and higher, but only 30 chars for earlier versions. 

 

Check your SQL statements for identifiers that might be too long and see if you can shorten them.