Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00972: identifier is too long

936666Oct 26 2012 — edited Oct 29 2012
I am having a query which will be inserting to table of 110 columns , where the values of 110 column length is about 1600 which i have spitted accordingly and i tried to insert the records into the table while inserting i am getting the below error

ORA-00972: identifier is too long

the 110 columns is the combinations of float ,number, var-char, char time ,date so i have spitted accordingly. my table name length is 13 character and i have used only single quotes for insertion

The insertion string length with comma separation is around 1710

Eg: insert into mytable values(1,2,'a',1,2,'b',time.............................)
Total length of my above string is about 1710

Thanks!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 25 2012
Added on Oct 26 2012
22 comments
8,576 views