Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Can I rename an index?

Re: Can I rename an index?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 14 Feb 2001 20:39:46 +0100
Message-ID: <t8m1pcgg9brj64@beta-news.demon.nl>

"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US