Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Does NOVALIDATE work in O8iR2?

Re: Does NOVALIDATE work in O8iR2?

From: Alex V. Burak <aburak_at_mail.itera.kiev.ua>
Date: Mon, 27 Nov 2000 17:03:04 +0200
Message-ID: <3A2277A8.A1F01E04@mail.itera.kiev.ua>

this from doc

ALTER TABLE dept
ENABLE NOVALIDATE PRIMARY KEY,
ENABLE NOVALIDATE UNIQUE (dname, loc);

Brian Tkatch wrote:
>
> On Mon, 27 Nov 2000 09:26:29 +0200, "Alex V. Burak"
> <aburak_at_mail.itera.kiev.ua> wrote:
>
> >hi
> >i cannot force to work even simple example
> >with primary key
> >Oracle 8i 8.1.6.0
> >--
> >Alex V. Burak
> >IT Manager
>
> I'm guessing here.
>
> A primary key also means creating a unique index. The unique index is
> rejecting the novalidate clause.
>
> Brian
 

-- 
Alex V. Burak
IT Manager
Received on Mon Nov 27 2000 - 09:03:04 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US