Re: HELP: Changing index names

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