Re: Apparently, an error (or another Oracle puzzle a-la Daniel)

"Noons" <wizofoz2k_at_yahoo.com.au> wrote in message news:<403f5661$1$29132$afc38c87_at_news.optusnet.com.au>...
> "Thomas Wagner" <twapriv-nospam_at_yahoo.com> wrote in message
> news:3a07da7d.0402260900.fc0f62b_at_posting.google.com...
>
>
> > SQL>alter table x enable constraint c1;
> >
> > Table altered.
> >
> > SQL>desc x
> > Name Null? Type
> > ----------------------------------------- -------- --------------------------
> --
> > N1 NOT NULL NUMBER
> > N2 NUMBER
>
>
> Yup, you got it. Which brand of single malt? :)
>
> Funny one, eh? I don't think this happens with older versions
> as NOT NULL was not rally handled as a constraint.
> With 9i it happens as expected of any constraint, it's just
> that describe doesn't tell us the full story.

Same happens in 817. I stumbled over this one a couple of months ago when working on some ddl upgrade scripts for our app.

Since I'm an austrian living in nyc and it's really hard to get austrian beer here I'd say Goesser is the malt of choice.

Cheers
Thomas Received on Fri Feb 27 2004 - 14:39:47 CST