Home » RDBMS Server » Performance Tuning » Index Partition rebuild Query
Index Partition rebuild Query [message #122135] Fri, 03 June 2005 03:16 Go to next message
Messages: 86
Registered: September 2004


I want to build following script using sql query on oracle dictionary table.Something like

sql> Select 'ALTER INDEX '|| index_name ||' rebuild partition'

e.g.ALTER INDEX <index_name> REBUILD PARTITION <partition_name>

How can I achieve the same?I searched for dictionary tables but could not find any oracle dictionary table where I can find index name along with its partition name.


Re: Index Partition rebuild Query [message #122160 is a reply to message #122135] Fri, 03 June 2005 08:16 Go to previous message
Messages: 18
Registered: May 2005
Junior Member

You can query the table USER_IND_PARTITIONS (or ALL_IND_PARTITIONS if you run under another user than the index owner) to get index and partition names.

Best regards

Previous Topic: The same sql runs very slowly in jboss-cmp,very quickly in native jdbc.
Next Topic: Select on same table gives poor performace.
Goto Forum:

Current Time: Mon Mar 04 19:34:05 CST 2024