Re: Creating an indexing policy on long columns error

From: Jonathan Lewis <>
Date: Thu, 27 May 1999 22:45:01 +0100
Message-ID: <>

[Quoted] 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:

s wrote in message <>...

>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
>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
>// *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 Thu May 27 1999 - 23:45:01 CEST

Original text of this message