Re: Creating an indexing policy on long columns error

[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: 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.