Re: Can I rename an index?

I only discovered this one about 6 months ago - and it was only a couple of weeks ago that someone else pointed out to me that RENAME also works for synonyms.

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases
Publishers:  Addison-Wesley

Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



Syltrem wrote in message ...


>INDEED. SQL command syntax is sometimes confusing. You have a RENAME

 command


>that only works for tables so I figured there was nothing for indexes.

>ALTER TABLE RENAME is there, too so we've got 2 ways to rename a table

 (just


>trying to apologize for asking questions that appear to be of RTFM nature).

>