Oracle E - Business Suite
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
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment