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.