Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Rename of an Index or Primary Key
Hi
You can use this command:
ALTER INDEX index_current rename to index_new
Kurien
Hilton Pereira wrote:
> 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
Received on Tue Apr 20 1999 - 14:41:33 CDT