Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> ConText indexing error
Hi,
the other day I posted a question about a terribly long ConText indexing process. Thanks to Thomas Kyte, it proved that the indexing process was actually hanging (still consuming lots of CPU cycles, however) due to insufficent SYSTEM tablespace. (Which I cannot explain, as the SYSTEM tablespace is set autoextend unlimited)
Changing the default tablespace for ctxsys helped, however, now I get some other error that is not amusing, either:
(remark: those might not be the original error messages, I translated them from German to English, as I set my NLS variables to German...)
TEST_at_gerhard:orcl SQL(16)> EXECUTE CTX_DDL.CREATE_INDEX(
'udk_schlagwortede_soundex', 1 );
begin CTX_DDL.CREATE_INDEX( 'udk_schlagwortede_soundex', 1 ); end;
*
ERROR at line 1:
ORA-20000: ConText error:
DRG-00100: Internal Error; Arguments:
[50853],[/m/ctx_src_2/src/dr/dreb/drebk.c],[662],[],[]
ORA-01401: Inserted Value to large for column. ORA-06512: at "CTXSYS.DRUE", line 110 ORA-06512: at "CTXSYS.CTX_DDL", line 245 ORA-06512: at line 1
What the hell is happening here?
I use a rather large stop word list (250 entries), soundex, German
stemming, HTML filtering, 50 MByte reserved RAM for the engine, and
some other preferences that should cause no problem.
The attribute to index is a VARCHAR2(700) type, and the textkey is VARCHAR2(37). I use ConText option 1.x on a DEC alpha OSF 1, v4.0c and Oracle RDBMS 7.3
What did I do wrong?
Thanks for any help, Gerhard. Received on Thu Oct 02 1997 - 00:00:00 CDT
![]() |
![]() |