Re: Renaming primary and /or unique keys

From: Jens Lenge <spampot_at_gmx.net>
Date: 13 Jul 2006 13:16:41 -0700
Message-ID: <1152821801.519836.171270@m79g2000cwm.googlegroups.com>

Maxim Demenko wrote:
> Tables, indexes and constraints resides in different namespaces, which
> means, you can have a table , index and constraint named the same. Hence
> , you can rename your index and constraints to the same identifier.

I have just tried to create a new index for the existing primary key constraint (using Oracle SQL Developer):

=> Error: Name pk_mytable_id is already used by table mytable.

Jens Lenge wrote:
> I was out for an example of how to disable/reenable and rename both the
> constraint and index as you originally suggested.

To be more specific, disabling the constraint only works as long as it is not referenced by other tables. But when I try to disable my primary key, I get an error saying it cannot be disabled because it is referenced... Received on Thu Jul 13 2006 - 15:16:41 CDT