Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Can I rename an index?
"Syltrem" <syltrem_at_videotron.ca> wrote in message
news:a5Bi6.8673$QB4.169133_at_wagner.videotron.net...
> 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
> >
> >
> >
>
>
Short answer : No
Hth,
Sybrand Bakker, Oracle DBA Received on Wed Feb 14 2001 - 13:39:46 CST