| Follow up by mail | Click here |
| Subject: | RE: ORA-29877: failed in the execution of the ODCIINDEXUPDATE routine |
| Author: | Simon Wickham, United Kingdom |
| Date: | Mar 08, 2010, 185 days ago |
| Os info: | Solaris 9 |
| Oracle info: | 9.2.0.8 |
| Error info: | UPDATE thing SET field = NVL((SELECT t.name
* ERROR at line 1: ORA-29877: failed in the execution of the ODCIINDEXUPDATE routine ORA-20000: Oracle Text error: DRG-10602: failed to queue DML change to column for primary key DRG-10011: invalid object name <NAME> ORA-30576: ConText Option dictionary loading error |
| Message: | Hi,
I am trying to update a column within a table called field from a temp table with the following SQL statement. Could anyone explain what is going wrong. CREATE TABLE temp_table (uppername VARCHAR2(256), name VARCHAR2(256)); INSERT INTO temp_table (uppername, name) values ('BLAH','blah'); UPDATE <TABLE_NAME> SET field = NVL((SELECT t.name FROM temp_table t WHERE t.uppername = UPPER(field) ), field); UPDATE thing SET field = NVL((SELECT t.name * ERROR at line 1: ORA-29877: failed in the execution of the ODCIINDEXUPDATE routine ORA-20000: Oracle Text error: DRG-10602: failed to queue DML change to column for primary key DRG-10011: invalid object name <NAME> ORA-30576: ConText Option dictionary loading error Regards, Simon |
| Goto: | Reply - Top of page |
| Subject: | Re: RE: ORA-29877: failed in the execution of the ODCIINDEXUPDATE routine |
| Author: | Guy Lambregts, Other |
| Date: | Mar 08, 2010, 185 days ago |
| Message: | Hi
Check what the status of your domain index is in all_indexes view. What I think to remember about this error is gthat your index is in an unusable or loading state. Check context index metadata. Regards Guy |
| Your rating?: | This reply is Good Excellent |
| Goto: | Reply - Top of page |
| Subject: | Re: RE: ORA-29877: failed in the execution of the ODCIINDEXUPDATE routine |
| Author: | Simon Wickham, United Kingdom |
| Date: | Mar 09, 2010, 184 days ago |
| Message: | Hi,
I have looked at the all_indexes view and queried the following: SQL> SELECT OWNER, TABLE_NAME, DOMIDX_STATUS, DOMIDX_OPSTATUS, STATUS FROM ALL_INDEXES 2 WHERE OWNER = 'SCHEMA' 3 / Which show the status as valid. Any idea where else to look. Thanks |
| Your rating?: | This reply is Good Excellent |
| Goto: | Reply - Top of page |
| Subject: | Re: RE: ORA-29877: failed in the execution of the ODCIINDEXUPDATE routine |
| Author: | Guy Lambregts, Other |
| Date: | Mar 09, 2010, 184 days ago |
| Message: | Hi
Can you post us the domain index creation DDL ? If it is a context index, what do you have in place for index synchronization ? regards Guy |
| Your rating?: | This reply is Good Excellent |
| Goto: | Reply - Top of page |
| Subject: | Re: RE: ORA-29877: failed in the execution of the ODCIINDEXUPDATE routine |
| Author: | Simon Wickham, United Kingdom |
| Date: | Mar 15, 2010, 178 days ago |
| Message: | Hi Guy,
Sorry realized I had not got back to you. The issue was the original import by another person had errors so resolved and all ok. Thanks, Simon |
| Your rating?: | This reply is Good Excellent |
| Goto: | Reply - Top of page |