Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Does NOVALIDATE work in O8iR2?
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 ManagerReceived on Mon Nov 27 2000 - 09:03:04 CST