Error in 9.0.1.3.0:
ORA-29902: error in executing ODCIIndexStart() routine
Fixed in 9.2.0.3.
Sounds it comes back again in 9.2.0.6 as reproduced by oracle
TESTCASE
-----------------------
Unfortunately, ctx_adm.mark_failed does not fix the problem:
.
SQL> alter index story_test_text_idx rebuild partition p1985 parameters
('resume');
alter index story_test_text_idx rebuild partition p1985 parameters ('resume')
*
ERROR at line 1:
ORA-29952: cannot issue DDL on a domain index partition marked as LOADING
.
SQL> connect ctxsys/ctxsys;
Connected.
.
SQL> begin
2 ctx_adm.mark_failed('TEST','STORY_TEST_TEXT_IDX');
3 end;
4 /
.
PL/SQL procedure successfully completed.
.
SQL> connect test/test;
Connected.
.
SQL> alter index story_test_text_idx rebuild partition p1985 parameters
('resume');
alter index story_test_text_idx rebuild partition p1985 parameters ('resume')
*
ERROR at line 1:
ORA-29952: cannot issue DDL on a domain index partition marked as LOADING
