Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Intermedia Text index creation error.
trying turning off archiving during the index process.
"Faizal Abdoelrahman" <faizal_at_sara.nl> wrote in message
news:3BA71472.FFAB432C_at_sara.nl...
> 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
Received on Thu Sep 20 2001 - 07:43:03 CDT