Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: PK with no index
How can I base my primary key on an existing index?
coakleyj_at_hotmail.com wrote:
> Hi Doug.
> It is likely that the primary key has been disabled.
> Disabling will automatically drop the corresponding
> index (unless of course you're using Oracle 8 and you
> based your primary key on an existing index).
> Check the status field in the user_constraints table.
>
> Cheers
> Coakleyj
>
> In article <37933801.1F97257B_at_bigfoot.com>,
> Doug Cowles <dcowles_at_bigfoot.com> wrote:
> > Found a primary key constraint on a table, let's say A.
> > There are NO indexes on A. No Sys_C0439 blah blah,
> > not anything. Checked DBA_INDEXES. Nothing.
> > How can a primary key constraint exists on a table with
> > no corresponding index of any kind? Has something gone
> > kafluoey?
> >
> > - Dc.
> >
> >
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Mon Jul 19 1999 - 14:08:42 CDT