Re: PK with no index

From: <coakleyj_at_hotmail.com>
Date: Mon, 19 Jul 1999 18:22:05 GMT
Message-ID: <7mvqbt$3pu$1@nnrp1.deja.com>

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 - 13:22:05 CDT