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]

