Re: Rename of an Index or Primary Key

From: Graham C Thornton <graham.thornton_at_ln.ssw.abbott.com>
Date: Mon, 22 Mar 1999 09:04:03 -0600
Message-ID: <7d5m6m$b93@news.abbott.com>

Hilton Pereira wrote in message <36F05A9E.65B6D78D_at_platinum.com>...
>Hi,
> Does anybody know of a way to rename indexes,constraints
>without having to drop and recreate them in Oracle 7 .
>By the way Oracle 8 has added rename syntax in the alter index
>statement.
>Thanks
>
>

As with most database entities, (columns, tablespaces etc.) indexes and constraints can be renamed by directly modifying the data dictionary. However, as always, this should only be done with extreme caution and only when other options have been ruled out.

Good luck

Graham Received on Mon Mar 22 1999 - 09:04:03 CST