hi,

please try this for rebuild index per partition:
alter index <schema>.<indexname> rebuild partition <partition_name>;

smoga membantu 





________________________________
From: sigit budiono <[email protected]>
To: [email protected]
Sent: Thu, October 15, 2009 12:40:37 PM
Subject: [indo-oracle] Rebuild index @ partitioned table

  
Dear Master,Mohon petunjuknya gimana cara rebuild index dari patitioned
table.
Tabel saya berpartisi tiap bulan, saya mau pindahin index bulan januari dari
tablespace idx_Januari ke tablespace idx_Januari1.

Mohon bantuannya.. .

[Non-text portions of this message have been removed]


   

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

[Non-text portions of this message have been removed]

Kirim email ke