Re: ConText: double keys problem?

From: Gerhard Moeller <Gerhard.Moeller_at_OFFIS.Uni-Oldenburg.de>
Date: 1997/10/07
Message-ID: <61cs29$6t@news.Informatik.Uni-Oldenburg.DE>#1/1

Garrett Kaminaga <gkaminag_at_us.oracle.com> wrote:

>Gerhard Moeller wrote:
>> *
>> 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.
>> .
>
>As stated in an earlier post, for version 1.1 your textkeys cannot
>be longer than 32 chars. This is a known bug with 1.1 which
>was corrected with version 2.0.4 and above.

But the textkey I use in the above policy is just a NUMBER! And it is also used as the PRIMARY KEY of the table. And the constraint (primary key) is VALID.

>version 2.0.4 of ConText is avail for 7.3.3 of the database.
>Suggest upgrading to that version.

I really would love to do so. I just do not know if the latest ConText option works in our environment.

Maybe someone can help me with that information?

Our configuration:

SYSTEM_at_gerhard:orcl SQL(16)> select * from v$version; Hit Enter To Continue...

BANNER

---

Oracle7 Server Release 7.3.2.3.0 with the 64-bit option - Produc PL/SQL Release 2.3.2.3.0 - Production
CORE Version 3.5.2.0.0 - Production
TNS for DEC OSF/1 AXP: Version 2.3.2.1.0 - Production NLSRTL Version 3.2.2.0.0 - Production

The OS is OSF/1 on a DEC alpha server,
Digital UNIX [UNI] V4.0B (Rev. 564); Tue Jul 8 16:15:36 WET DST 1997

If you could drop me a note, what ConText version I need, and possibly what patches for the DBMS and/or OS, I would be very thankful and call our sales representant. (The more precise I could tell them what I need, the better, as I had many problems getting all necessary patches for the Webserver 2.1)

        Thank you very, very much,

                Gerhard. Received on Tue Oct 07 1997 - 00:00:00 CDT