1 Reply Latest reply: Dec 17, 2012 7:21 AM by Osama_Mustafa RSS

    ORA-00972: identifier is too long

    980290
      hi!

      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.