Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: orace sql query
On Jun 22, 3:45 pm, DA Morgan <damor..._at_psoug.org> wrote:
> EdStevens wrote:
> > On Jun 22, 12:15 pm, sathishkes..._at_gmail.com wrote:
> >> i want to create table with primary key but with out index
>
> > How do you think Oracle enforces the PK?
>
> Not with an index. Indexes have nothing to do with primary key
> enforcement. Consider, for example, a deferred constraint which
> is built with a non-unique index.
> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org
David,
Now I'm really puzzled. My question back to the OP was to suggest to him that you can't have a PK without and index (backed up by the Concepts Manual stateing "Oracle enforces all PRIMARY KEY constraints using indexes.") But after taking me to task on that, you respond back to the OP that what he wants is impossible -- exactly what I was trying to get the OP to think through and discover for himself. What am I missing? Received on Mon Jun 25 2007 - 20:33:50 CDT