An simple issue:ORA-00972: identifier is too long

An simple issue:ORA-00972: identifier is too long

分类： ORACLE11G 2011-02-24 09:35 478人阅读 评论(0) 举报

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
)