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
bhagwan
Messages: 86
Registered: September 2004
Member
Hi,

Database:8.1.7

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.

Rgds,
Bhagwan


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

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: Tue Mar 19 00:51:44 CDT 2024