Monday, August 17, 2009

Reorg Table Partiton

2) Table Partiton

ALTER TABLE
MOVE PARTITION
TABLESPACE ;

Dba_tab_partitions -- to get the partition name

3) Table Subpartition

ALTER TABLE
MOVE SUBPARTITION
TABLESPACE ;

Dba_tab_subpartitions - to get the subpartition name

1 comment:

Jennifer N said...

Thanks and Regards. Oracle Apps R12 Training Videos at affordable cost. please check oracleappstechnical.com