Re: relaxing the unique key constraint for a transaction

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 23 Aug 2001 04:10:10 -0700
Message-ID: <a20d28ee.0108230310.60b13a2f_at_posting.google.com>

gkonduri_at_us.oracle.com (Gangadhar) wrote in message news:<578815ac.0108221716.6bac3299_at_posting.google.com>...
> Hi,
>
> I have a case where i need to do an update to the rows in a database
> which temporarily violates the unique key constraint in the database.
> I was wondering if i can temporarily relax the uniqueness check for my
> transaction without
> affecting other users.
>
> Thanks in advance,
> Gangadhar

No.
An unique constraint is imposed on table level and hence affects all users. If you disable it, it will be disabled for all users. I can hardly believe anyone from Oracle is asking such a question. Maybe I should consider switching to DB2.

Yikes!

Regards,

Sybrand Bakker, Senior Oracle DBA Received on Thu Aug 23 2001 - 13:10:10 CEST

This message: [ Message body ]
Next message: Anurag Varma: "Re: relaxing the unique key constraint for a transaction"
Previous message: origin: "Does noone have any example for on select, on fetch, on close trigger ???????"
In reply to Gangadhar: "relaxing the unique key constraint for a transaction"
Next in thread: Anurag Varma: "Re: relaxing the unique key constraint for a transaction"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message