From: iolo@my-dejanews.com Subject: Re: ConText problem Date: 1998/07/07 Message-ID: <6nso3e$7k7$1@nnrp1.dejanews.com>#1/1 References: <35A0E8B6.A4D94CC6@elucidate.com> X-Http-User-Agent: Mozilla/4.05 [en] (WinNT; I) via proxy gateway CERN-HTTPD/3.0 libwww/2.17 Organization: Deja News - The Leader in Internet Discussion X-Article-Creation-Date: Tue Jul 07 09:00:31 1998 GMT Newsgroups: comp.databases.oracle.tools,comp.databases.oracle.misc,comp.databases.oracle.server,comp.databases.oracle.marketplace In article <35A0E8B6.A4D94CC6@elucidate.com>, David Schwartz wrote: > > > I'm trying to use ConText on a UNIX OS. I set up a table and a policy, > but when I run ctx_ddl.create_index on the policy name, the command > prompt > never returns, i.e. the program gets stuck somewhere. When I Cntl-C out > of it, I get the following message: > >

ERROR at line 1: >
ORA-20000: ConText error: >
DRG-10302: interrupted waiting for responses from servers >
ORA-06512: at "CTXSYS.DRUE", line 180 >
ORA-06512: at "CTXSYS.CTX_DDL", line 94 >
ORA-06512: at line 1 >
> >

All the servers are up, including one with a DDL personality, and I'm > > stumped. If anyone can give me a hint as to what may be causing the > problem, > I'd really appreciate it. > >

Thanks a lot > >

For reference, the table and policy I'm using for testing are: > >

create table TESTTABLE ( >
PK varchar(64) primary key not null, >
TEXTCOL varchar(100) not null >
); > >

begin >
ctx_ddl.create_policy( >
    policy_name => 'TESTTABLE_POL', >
    dstore_pref => > 'CTXSYS.DEFAULT_DIRECT_DATASTORE', >
    engine_pref => 'CTXSYS.DEFAULT_INDEX', >
    filter_pref => > 'CTXSYS.DEFAULT_NULL_FILTER', >
    lexer_pref => 'CTXSYS.DEFAULT_LEXER', >
    wordlist_pref => 'CTXSYS.NO_SOUNDEX', >
    stoplist_pref => 'CTXSYS.DEFAULT_STOPLIST', > >

    colspec => 'TESTTABLE.TEXTCOL', >
    textkey => 'PK' >
    ); >
end; >
/ > > When I evaluated Context some while back on a 150000 row - 40 column table it took about 4 hours to create the index. Maybe you'll just have to be patient ! Regards, Oliver Willandsen European Commission http://europa.eu.int -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum