Intermedia Text index creation error.

Hi,

I am experiencing index creation errors on a VARCHAR2(255) column with Oracle 8.1.7 on AIX 4.3.

I implemented the following preference:

begin
ctx_ddl.create_preference('my_text_pref', 'BASIC_WORDLIST'); ctx_ddl.set_attribute('my_text_pref','substring_index','true'); end;

and then went on to create the index...

create index label_text on dbdescrelement(label) indextype is ctxsys.context parameters('wordlist my_text_pref memory 50M')  *
 ERROR at line 1:

 ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
 ORA-20000: interMedia Text error:
 DRG-50857: oracle error in dreii0fsh
 ORA-01562: failed to extend rollback segment number 2
 ORA-01628: max # extents (32765) reached for rollback segment RBS01
 ORA-06512: at "ORPROJ.DR$LABEL_TEXTTM", line 1
 ORA-04088: error during execution of trigger 'ORPROJ.DR$LABEL_TEXTTM'
 ORA-06512: at "CTXSYS.DRUE", line 126
 ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 78
 ORA-06512: at line 1

Increasing the rbs datafile's size from 0.5 GB to 6 GB doesn't help either.
Furthermore the table only contains 300000 records. It looks like the created trigger is the cause. Also the redo files are quickly filled up, and I have made 2 * 100 MB redo files.
Does anybody know some helpfull system tables to look at. Or better how can I monitor/follow the index creation process.

--

Faizal
SARA
Amsterdam