Creating an indexing policy on long columns error

From: s <skbleich_at_ix.netcom.com>
Date: Thu, 27 May 1999 14:38:14 -0700
Message-ID: <374DBB46.6D69BE18@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.

Is there any other way to get around this, without having the primary key column limited in such a way?

Thanks. Received on Thu May 27 1999 - 16:38:14 CDT