Re: relaxing the unique key constraint for a transaction

postbus_at_sybrandb.demon.nl (Sybrand Bakker) wrote in message news:<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

thanks! never worked on db-related issues before.. so , u can stay on oracle! :) Received on Thu Aug 23 2001 - 21:07:04 CEST