ConText: double keys problem?

From: Gerhard Moeller <Gerhard.Moeller_at_OFFIS.Uni-Oldenburg.de>
Date: 1997/10/05
Message-ID: <618i51$ua9@news.Informatik.Uni-Oldenburg.DE>#1/1

Hi,

this seems to become a never ending story...

After I found, that (other than stated in the manual!) the names of the policies cannot be up to 60 characters long, and the size of the textkey cannot be up to 64 characters long, I still do not get things working.

My latest problem is: (I retranslated the error messages to English, so they might not be 100% identical to the ones you get when NLS=american)

---

TEST_at_gerhard:orcl SQL(16)> EXECUTE CTX_DDL.CREATE_INDEX( 'soifs_title_de_soundex', 1 );
begin CTX_DDL.CREATE_INDEX( 'soifs_title_de_soundex', 1 ); end;

*
ERROR in line 1:

ORA-20000: ConText error:
DRG-51201: Error executing DDL-operation: object TEST.DR_01583_KIK.
DRG-10538: Textindex index TEST.DR_01583_KIK can
ORA-01452: CREATE UNIQUE INDEX cannot be executed; double keys found.

.

ORA-06512: in "CTXSYS.DRUE",  line 110
ORA-06512: in "CTXSYS.CTX_DDL",  line 245
ORA-06512: in  line 1

---

This is quite astonishing, as the textkey I use is the PRIMARY KEY of the table. It sure is (has to be) unique. How can ConText find a double entry?

I use ConText option 1.1 -- if this is the problem.

Things are really getting frustrating by now. ;-)

        Thank you very much for any help, Gerhard. Received on Sun Oct 05 1997 - 00:00:00 CDT