Forum Stats

  • 3,769,338 Users
  • 2,252,950 Discussions
  • 7,874,992 Comments

Discussions

series of index related errors after executing an update

user7029403
user7029403 Member Posts: 7
edited Jul 4, 2013 6:52AM in General Database Discussions

Hello.

I am trying to execute this update sentece to eliminate all appearances of the high quote character in all the rows in a column:

-----

update seccion_iii set organo = replace(organo, '"');

----

But it always fails with this errors:

------------------------------------------

ERROR en línea 1:

ORA-29877: fallo al ejecutar la rutina ODCIINDEXUPDATE

ORA-20000: Error de Oracle Text:

DRG-50857: oracle error in textindexmethods.ODCIIndexUpdate

ORA-20000: Oracle Text error:

DRG-10602: fallo al poner en cola el cambio DML de columna ORGANO para la clave

primaria AAAYJWAAGAABnE9AAU

DRG-50857: oracle error in drekqkd (n_stmt)

ORA-01654: no se ha podido ampliar el índice BOCM.SYS_IOT_TOP_108058 con 128 en

el tablespace BOLETIN_TBS

ORA-06512: en línea 1

ORA-06512: en "CTXSYS.DRUE", línea 160

ORA-06512: en "CTXSYS.TEXTINDEXMETHODS", línea 747

-------------------------------------------

I guess an approximate translation would be:

------------------------------------------

ERROR in line 1:

ORA-29877: failed to execute the routine ODCIINDEXUPDATE

ORA-20000: Oracle Text error:

DRG-50857: oracle error in textindexmethods.ODCIIndexUpdate

ORA-20000: Oracle Text error:

DRG-10602: failed to add to the queue the DML change of column ORGANO for the primery key AAAYJWAAGAABnE9AAU

DRG-50857: oracle error in drekqkd (n_stmt)

ORA-01654: could not extend the index BOCM.SYS_IOT_TOP_108058 with 128 on tablespace BOLETIN_TBS

ORA-06512: in line 1

ORA-06512: in "CTXSYS.DRUE", line 160

ORA-06512: in "CTXSYS.TEXTINDEXMETHODS", line 747

-------------------------------------------

It seems there is a problem with the index asociated with that column, but I do not even know where to begin.

I am using Oracle 11g for Windows Server

Thank you very much.

Tagged:

Best Answer

  • DK2010
    DK2010 Member Posts: 1,542 Silver Trophy
    Accepted Answer

    Hi

    check this line

    ORA-01654: could not extend the index BOCM.SYS_IOT_TOP_108058 with 128 on tablespace BOLETIN_TBS


    You need to add space on tablespace BOLETIN_TBS and then try


    HTH

Answers

This discussion has been closed.