Re: Strange error with Oracle 10g XE

From: Jens Lenge <spampot_at_gmx.net>
Date: 28 Sep 2006 02:45:41 -0700
Message-ID: <1159436741.375604.258790@d34g2000cwd.googlegroups.com>

Sybrand Bakker wrote:

> I would guess you could set the constraint to enabled novalidate in
> both versions, and this would actually constitute a *better* solution
> (instead of just dropping the constraint completely, which is pretty
> dangerous)

I agree and will definitely follow your suggestion.

However, at some place I still need to drop the pk constraint because I need to set a new pk constraint that refers to a different column. But I guess you're right and it is probably less dangerouse to drop the old and create the new pk constraint without manipulating the data in between. Received on Thu Sep 28 2006 - 04:45:41 CDT