OraFAQ Forum: Server Administration » How to rename a lob index created by Oracle ?

Home » RDBMS Server » Server Administration » How to rename a lob index created by Oracle ?

Mon, 15 May 2006 08:33

Ivancleber da Silva Neves
Messages: 74
Registered: July 2002

Member

How to rename a lob index created by Oracle ?

Thanks in advance

Tue, 16 May 2006 01:37

kmsalih
Messages: 197
Registered: March 2006

Senior Member

Try this

Alter index <old_index_name> rename to <new_index_name>;

Rgds
SALIH KM

Thu, 14 September 2006 23:49

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: Fri Sep 20 06:24:16 CDT 2024