Re: Can I rename an index?

"Syltrem" <syltrem_at_videotron.ca> wrote in 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
>
>
>

alter table <table_name> drop constraint <constraint_name>

Hth,

Sybrand Bakker, Oracle DBA Received on Wed Feb 14 2001 - 13:30:49 CST