An simple issue:ORA-00972: identifier is too long-优快云博客

本文探讨了在Oracle数据库中遇到ORA-00972错误的原因及解决方案，该错误通常由过长的标识符引起。通过调整SQL语句中的字段值并确保所有标识符符合长度限制，可以有效解决此问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Got an error ORA-00972: identifier is too long from developers.

They said the SQL cause the issue:

insert into jpa values ("f1ffc73a-90a8-44da-ad32-c07b01b7d9a6","+Eq5K5esQwC7THKEP51Y+Q==","+Eq5K5esQwC7THKEP51Y+Q==","UXkHnKkw==","d3zqz62IE6bzgvfGzwsy49Mdb9ssssHr9D2c4CrArCeH1ZY5Or4B7ie3yPDOhY/5PBK5+CibsftoAt6RzwvimG1/kGMcjlU6x4rdAm/aBI5BDK9LpbTcCPVhJRpSDwnyBw8kcePP8svFZXFCWwbrVnQyQvs1qYGFJGSVtplSugcx1qoj3O+fovDsVvfm0TGViYQXTNYNr68kBO",-1,"",87,0;

Usually,This thing can happen if you are having any column name whose length is more than 30.
SQL> create table abc( iiiiiiiiiiiiiiiiiiiiiiiiiiiiiii number) ;

create table abc( iiiiiiiiiiiiiiiiiiiiiiiiiiiiiii number) *

ERROR at line 1: ORA-00972: identifier is too long

SQL> create table abc( iiiiiiiiiiiiiiiiiiiiiiiiiiiiii number) ;

Table created.

But obviously the error is not caused by this.

SQL> select * from jpa;

no rows selected

SQL> desc jpa
Name Null? Type
----------------------------------------- -------- ----------------------------
UUID NOT NULL VARCHAR2(100)
FIELD1 NOT NULL VARCHAR2(100)
FIELD2 NOT NULL VARCHAR2(100)
FIELD3 VARCHAR2(4000)
FIELD4 CLOB
FIELD5 NUMBER(20)
FIELD6 VARCHAR2(100)
FIELD7 NOT NULL NUMBER(20)
FIELD8 NUMBER(3)

I modify the sql like this then it work:

insert into jpa values ('f1ffc73a-90a8-44da-ad32-c07b01b7d9a6','+Eq5K5esQwC7THKEP51Y+Q==','+Eq5K5esQwC7THKEP51Y+Q==','UXkHnKkw==','d
3zqz62IE6bzgvfGzwsy49Mdb9ssssHr9D2c4CrArCeH1ZY5Or4B7ie3yPDOhY/5PBK5+CibsftoAt6RzwvimG1/kGMcjlU6x4rdAm/aBI5BDK9LpbTcCPVhJRpSDwnyBw8kc
ePP8svFZXFCWwbrVnQyQvs1qYGFJGSVtplSugcx1qoj3O+fovDsVvfm0TGViYQXTNYNr68kBO',-1,'',87,0
)