Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Rebuild Partitioned Tables Indexs

user7439393Sep 11 2012 — edited Sep 11 2012

Hi Team,

Please let me the rebuild of partitioned table indexes .

For tables I am using below which is working fine...............

ALTER TABLE PB_STG_GEN.ABLM_CB_ACCOUNT_SERVICE_LIST move partition P_BATCH_ID tablespace TS_STG_GEN parallel 5;

Please help me with DYNAMIC ( Script Generation ) for to rebuild above partitioned table indexes.

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 9 2012

Added on Sep 11 2012

#general-database-discussions

22 comments

9,885 views