Re: Can I rename an index?

Found it - ALTER TABLE DROP CONSTRAINT.

But can an index be renamed still?

--

Sytrem
http://pages.infinit.net/syltrem

"Syltrem" <syltrem_at_videotron.ca> a écrit dans le message news:
n_Ai6.8651$QB4.168729_at_wagner.videotron.net...


> 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

>

>

>