An simple issue:ORA-00972: identifier is too long_err] ora-00972: identifier is too long-CSDN博客

本文链接：https://blog.csdn.net/henrybai/article/details/6204134

本文探讨了在尝试插入数据时遇到的ORA-00972错误：标识符过长，并通过修改SQL语句成功解决了该问题。文章详细展示了导致错误的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
)