| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: ConText problem
In article <35A0E8B6.A4D94CC6_at_elucidate.com>,
David Schwartz <davidschwartz_at_elucidate.com> wrote:
>
> <HTML>
> 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:
>
> <P>ERROR at line 1:
> <BR>ORA-20000: ConText error:
> <BR>DRG-10302: interrupted waiting for responses from servers
> <BR>ORA-06512: at "CTXSYS.DRUE", line 180
> <BR>ORA-06512: at "CTXSYS.CTX_DDL", line 94
> <BR>ORA-06512: at line 1
> <BR>
>
> <P>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.
>
> <P> Thanks a lot
>
> <P>For reference, the table and policy I'm using for testing are:
>
> <P>create table TESTTABLE (
> <BR> PK varchar(64) primary key not null,
> <BR> TEXTCOL varchar(100) not null
> <BR> );
>
> <P>begin
> <BR> ctx_ddl.create_policy(
> <BR> policy_name => 'TESTTABLE_POL',
> <BR> dstore_pref =>
> 'CTXSYS.DEFAULT_DIRECT_DATASTORE',
> <BR> engine_pref => 'CTXSYS.DEFAULT_INDEX',
> <BR> filter_pref =>
> 'CTXSYS.DEFAULT_NULL_FILTER',
> <BR> lexer_pref => 'CTXSYS.DEFAULT_LEXER',
> <BR> wordlist_pref => 'CTXSYS.NO_SOUNDEX',
> <BR> stoplist_pref => 'CTXSYS.DEFAULT_STOPLIST',
>
> <P> colspec => 'TESTTABLE.TEXTCOL',
> <BR> textkey => 'PK'
> <BR> );
> <BR>end;
> <BR>/</HTML>
>
>
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 Received on Tue Jul 07 1998 - 00:00:00 CDT
 |
 |