Re: HELP: Changing index names

I have to correct myself: this statement is not allowed for indexes.

Jaap.

Jaap W. van Dijk <j.w.vandijk_at_ptt-telecom.nl> schrijfbewerkingen: > 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