troubleshooting Question

Getting an ORA-00972: identifier is too long error when creating an index with multibyte characters using SQLPLUS

Avatar of jrram
jrramFlag for United States of America asked on
LinuxOracle Database
5 Comments1 Solution2416 ViewsLast Modified:
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.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 5 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros