RE: Help with sql identifying dup constraints

From: Jared Still <jkstill_at_cybcon.com>
Date: Thu, 10 Jun 2004 07:53:20 -0700
Message-Id: <1086879200.2159.8.camel@poirot>

I ran into this a few years ago, but I think it was on 7.3.4.

By using imp to reload data to an existing table, it seems that the NOT NULL constraints would be duplicated.

imp would just recreate them as CHECK constraints.

Not much fun to clean up.

Jared

On Thu, 2004-06-10 at 07:31, Duret, Kathy wrote:
> well, you can, at least in 8.1.4
>
> When I came here I found up to 10 not null constraints on the same
> columns.
>
> Got them all off and found some again.... seemed the other choke ...
> dba.... didn't understand that not null was a check constraints and
> for some reason kept putting them on ... I think via Toad (I never get
> a straight answer from him) Then we I showed him on some new tables
> he created all the dups, instead of deleted them, he disabled them
> all.....
>
> gotta love it. if there is a way in Oracle someone can use and abuse
> it!
>
> Kathy

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu Jun 10 2004 - 10:58:04 CDT