Next step I have tried to rebuild the index from scratch
I dropped the index
drop index cr_rev_content_index;
and recreated it.
The problem here is that
create index for context index type does not allow you to enter
storage option, and the default maxextents is applied.
This default in my case 249 extents which depends on your
db_block_size parameter (see: http://www.orapub.com/papers2/doc104.pdf )
To go around this limitation I have issued
create index cr_rev_content_index ....
and immediately after
ALTER TABLE MYUSER.DR$CR_REV_CONTENT_INDEX STORAGE ( UNLIMITED );
this helped to overcome maxextens issue but did not fix the problem as you will soon see:
ERROR at line 1:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: interMedia Text error:
DRG-50857: oracle error in drixtab.create_index_indexes
ORA-01237: cannot extend datafile 7
ORA-01110: data file 7: '/ora8/m01/app/oracle/oradata/ora8/drsys01.dbf'
ORA-19502: write error on file "/ora8/m01/app/oracle/oradata/ora8/drsys01.dbf",
blockno 347393 (blocksize=4096)
ORA-27072: skgfdisp: I/O error
Linux Error: 9: Bad file descriptor
Additional information: 347393
ORA-06512: at "CTXSYS.DRUE", line 126
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 78
ORA-06512: at line 1
as you see
drsys01.dbf grew so big that filled my disk partition ora8 and indexing failed
next step will be to move drsys01.dbf to another location and try again.
