This discussion is archived
1 Reply Latest reply: Dec 17, 2012 5:21 AM by Osama_Mustafa RSS

ORA-00972: identifier is too long

980290 Newbie
Currently Being Moderated

I notice the following alert log entries (in multiples) in one of the production databases and it keeps coming.

Mon Dec 17 12:43:09 2012
PRMX: Alter session failed: ORA-00972: identifier is too long
ORA-02248: invalid option for ALTER SESSION

ORA-00972: I tried looking up for object name, tablespace and even username with a value that was longer than 30 characters (as suggested in google search), but I didn't come across any.

ORA-02248: Don't have any clue.

I assume, both are related to some other issues.

Thanks in advance.


  • Correct Answers - 10 points
  • Helpful Answers - 5 points