Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

series of index related errors after executing an update

user7029403Jul 4 2013 — edited Jul 4 2013

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.

This post has been answered by DK2010 on Jul 4 2013
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 1 2013
Added on Jul 4 2013
2 comments
868 views