10 Replies Latest reply: Mar 16, 2012 3:47 PM by orafad RSS

    Getting ORA-01429 error while changing character set

    Chockalingam
      When I am changing character set from WE8DEC to AL32UTF8, I am getting ORA-01429 error


      SQL> ALTER DATABASE CHARACTER SET INTERNAL_USE AL32UTF8 ;
      ALTER DATABASE CHARACTER SET INTERNAL_USE AL32UTF8
      *
      ERROR at line 1:
      ORA-00604: error occurred at recursive SQL level 1
      ORA-01429: Index-Organized Table: no data segment to store overflow row-pieces