Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: HELP: Changing index names
Is this from the top of your head, Jerry? The correct syntax is
RENAME INDEX sys_c00676 TO <new_name>;
Doeg,
Jaap.
Jerry Gitomer <jgitomer_at_p3.net> schrijfbewerkingen: > Hi Geoff,
>
> ALTER INDEX sys_c00676 RENAME TO <new_name>;
>
> Regards
>
> Jerry
>
>
>
> Geoffrey Callaghan wrote:
> >
> > I'm trying to give the names of my Oracle indexes meaningful names, but
> > the system seems stuck on names like SYS_C00676. It won't allow me to
> > delete unique primary indexes, even if I intend to recreate them. I'm sure
> > there is a simple answer to this, but I'm out of ideas. Anyone know what
> > to do?
> >
> > Geoff Callaghan
> > callagha_at_cs.fsu.edu
>
> --
> Jerry Gitomer Since I know how to spell DBA I became one.
> jgitomer_at_p3.net
Received on Mon Mar 16 1998 - 00:00:00 CST