当前位置：网站首页>Operations related to Oracle partition

Operations related to Oracle partition

2022-04-23 13:40:00 【Wangcai 2】

View the data in the partition

select count(1) from  Table name  partition( Section name );

View the data in the sub partition

select count(1) from  Table name subpartition( Section name );

Delete partition （ After the operation , The partition and the data in the partition are gone ）

ALTER TABLE  Table name DROP PARTITION  Section name  update global indexes; 

Delete subpartition （ After the operation , There is no data in the sub partition and the sub partition ）

ALTER TABLE  Table name   DROP SUBPARTITION  Sub partition name  update global indexes; 

truncate Partition （ After the operation , The data in the partition is gone , But the partition is still ）

ALTER TABLE  Table name   TRUNCATE PARTITION  Section name  update global indexes; 

truncate Subarea （ After the operation , There is no data in the sub partition , But the sub partition is still ）
ALTER TABLE  Table name  TRUNCATE SUBPARTITION  Sub partition name  update global indexes; 

版权声明
本文为[Wangcai 2]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/04/202204230604301520.html

边栏推荐

猜你喜欢

随机推荐