Re: Student SQL question

From: Jurij Modic <jurij.modic_at_mf.sigov.mail.si>
Date: Tue, 19 May 1998 22:31:00 GMT
Message-ID: <35620814.11798004@www.sigov.si>

On 19 May 1998 11:42:56 GMT, oracle_at_tchp2.tcamuk.stratus.com (Neil Chandler) wrote:

>In article <01bd8279$03db4f80$049a0580_at_mcb>, "Matt Brennan" wrote:
>
> ....[SNIP].....
>RENAME table_name TO new_table_name;
>
>Note: You cannot rename indexes and they do not get renamed with this operation.

You can rename indexes if you are willing to mess around with sys tables (use this at your own risk as Oracle Support might not approve it):

UPDATE sys.obj$ SET name = '<new_index_name>'   WHERE namespace = 4 /* code for index object type */   AND name = '<old_index_name>';

>
>Neil Chandler
>TCAM Systems (UK) Ltd.
>Oracle DBA.

Regards,

---

Jurij Modic                             Republic of Slovenia
jurij.modic_at_mf.sigov.mail.si		Ministry of Finance
============================================================

The above opinions are mine and do not represent any official standpoints of my employer Received on Tue May 19 1998 - 17:31:00 CDT