Home » RDBMS Server » Server Administration » How to rename a lob index created by Oracle ?
How to rename a lob index created by Oracle ? [message #172201] Mon, 15 May 2006 08:33 Go to next message
Ivancleber da Silva Neves
Messages: 74
Registered: July 2002
Member
How to rename a lob index created by Oracle ?

Thanks in advance
Re: How to rename a lob index created by Oracle ? [message #172331 is a reply to message #172201] Tue, 16 May 2006 01:37 Go to previous messageGo to next message
kmsalih
Messages: 198
Registered: March 2006
Senior Member
Try this

Alter index <old_index_name> rename to <new_index_name>;

Rgds
SALIH KM
Re: How to rename a lob index created by Oracle ? [message #193123 is a reply to message #172331] Thu, 14 September 2006 23:49 Go to previous message
anurag078
Messages: 34
Registered: May 2006
Location: West Des Moines
Member

The above will not work.

You will get the below error:

ORA-22864: cannot ALTER or DROP LOB indexes


Anurag
Previous Topic: public synonyms
Next Topic: Partitioned table needs Partioned indexes?
Goto Forum:
  


Current Time: Thu Dec 08 04:31:01 CST 2016

Total time taken to generate the page: 0.05922 seconds