ORA-00972 identifier is too long

Question

I want to store more than 3500 characters in my table. so i used nvarchar2(3500) datatype for my Data field . but when i try to insert the data i get the error "ORA-00972: identifier is too long". Could anybody help me on this please.

I think it has to do with your insert statement. Could you paste it here? — Aditya Kakirde
Identifier too long means a column name or alias is too long (limit is 30 characters), nothing to do with your data. — Colin 't Hart
That's not a string, that's an identifier. Strings in Oracle use single quotes. So yes, if you are trying to use double quotes to delimit strings, use single quotes, like @MartinSmith comments. — Colin 't Hart

Spektakulatius Spektakulatius · Accepted Answer · 2017-12-01T07:02:31

CREATE TABLE T (D nvarchar2(1000)); 

INSERT INTO T (D) 
VALUES('This is a string longer than 30 characters')

Oracle has a restriction on Objectnames longer than 30 characters.

ORA-00972 identifier is too long

1 Answers