series of index related errors after executing an update

user7029403

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.

DK2010

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

DK2010

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

user7029403

Thank you very much. I couldn't deduce that from the error messages...