Re: Creating an indexing policy on long columns error

From: s <skbleich_at_ix.netcom.com>
Date: Thu, 27 May 1999 15:26:39 -0700
Message-ID: <374DC69F.97753B24_at_ix.netcom.com>


Jonathan --

ID = Number(11) not null, and is the primary key.

Thank you

Jonathan Lewis wrote:

> What were the type, uniqueness, and size of the ID column
> before you changed it to number(4) ?
>
> --
>
> Jonathan Lewis
> Yet another Oracle-related web site: www.jlcomp.demon.co.uk
>
> s wrote in message <374DBB46.6D69BE18_at_ix.netcom.com>...
> >We are running Oracle 8.0.5 on Solaris 2.6 with Context Cartridges.
> >I need to create indexing policies on some of the long data columns, and
> >when attempting to do so, I receive the following error message.
> >
> >
> >ERROR at line 1:
> >ORA-20000: ConText error:
> >DRG-10510: textkey column ID does not exist, is too long, or is not
> >unique
> >ORA-06512: at "CTXSYS.DRUE", line 180
> >ORA-06512: at "CTXSYS.CTX_DDL", line 1348
> >ORA-06512: at line 1
> >
> >When I do an oerr drg 10510 this is the explanation:
> >
> >10510,0, "textkey column %(1)s does not exist, is too long, or is not
> >unique"
> >// *Cause: the textkey specified is not a column of the text table
> >// ot its length exceeds 64 bytes.
> >// *Action: check the specified textkey
> >// *Mnemonic: DL_INV_TEXTKEY_SPEC
> >
> >I have created a test table with a long data type and a primary key with
> >data type number (4) and this works.
Received on Fri May 28 1999 - 00:26:39 CEST

Original text of this message