Getting an ORA-00972: identifier is too long error when creating an index with multibyte characters using SQLPLUS
Posted on 2009-12-17
I'm trying to create an index on a table that has multibyte characters in the table name and also field names. The index is created correctly if I execute it using Oracle SQL Developer or Tora.
But, when i issue the query using sqlplus, I get an "ORA-00972: identifier is too long error". Below is the query.
create index AP_V”NDÜR_05 on AP_V”NDÜR(V”NDÜR_ID, R”MIT_ADDR”SS_ID)
The characters in the .sql file that contains the create index statement looks correct when I view them in Putty. The file was created in Notepad++ with the UTF8 encoding set. I also created a second test file directly on the server using vi. Neither worked. Even issuing the query directly in sqlplus without piping in a file failed.
I'm out of ideas so I'd appreciate any ideas the community can provide.