Alter index sys_c00400 rename to my_pk;
--
Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
Practical Oracle 8i: Building Efficient Databases
Publishers: Addison-Wesley
Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html
Syltrem wrote in message ...
>I would like to rename an index but the RENAME command is only for
tables...
>Tried to drop it and recreate it, but could not do this either...
>
>SQL> DROP INDEX SYS_C0083054
> 2 ;
>DROP INDEX SYS_C0083054
>*
>ERROR at line 1:
>ORA-02429: cannot drop index used for enforcement of unique/primary key
>
>---------------------------------------------------------------------------
-
>02429, 00000, cannot drop index used for enforcement of unique/primary key
>
>// *Cause: user attempted to drop an index that is being used as the
>// enforcement mechanism for unique or primary key.
>// *Action: drop the constraint instead of the index.
>---------------------------------------------------------------------------
-
>
>Now how do I drop a constraint?
>
>Thanks!
>
>--
>
>Sytrem
>http://pages.infinit.net/syltrem
>
>
>
Received on Wed Feb 14 2001 - 14:15:59 CST
