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!

Error ORA-29855 Creating the Oracle Text Context index based on a clob field

orasiyaMay 17 2019 — edited May 17 2019

Hi Friends,

When I create the Oracle Text Context index based on a clob field (Audit Vault Server - event_log table command_text field), I gets the following errors

create index myindex on event_log(command_text_clob) indextype context

parameters('memory 1G')

-------------------- Error -----------------------

[Error] Execution (4: 1): Error: ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine

ORA-20000: Oracle Text error:

DRG-50857: oracle error in drvddl.IndexCreate

ORA-20000: Oracle Text error:

DRG-50857: oracle error in drekr2kFlush (execute insert)

ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS'

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

ORA-06512: location "CTXSYS.TEXTINDEXMETHODS", line 366

regards

Siyavus

Added on May 17 2019

#general-database-discussions

4 comments

692 views