原来table t中含有四个partition p1,p2,p3,p4
更改前
select count(1) from t partition(p1);
返回值:12346416
rename table t to t1后,
select count(1) from t1 partition(p1);
返回值:0.
请赐教,谢谢。
更改前
select count(1) from t partition(p1);
返回值:12346416
rename table t to t1后,
select count(1) from t1 partition(p1);
返回值:0.
请赐教,谢谢。
create table partition_test
(
score number
)
partition by range(score)
(
PARTITION s_60 VALUES LESS THAN (61),
partition s_70 values less than (71),
partition s_80 values less than (81),
partition s_90 values less than (91),
partition s_100 values less than (MAXVALUE)
);insert into partition_test values(58);
insert into partition_test values(59);
insert into partition_test values(60);
insert into partition_test values(61);
insert into partition_test values(70);
insert into partition_test values(80);
insert into partition_test values(90);
insert into partition_test values(99);
insert into partition_test values(100);select * from partition_test; select * from partition_test partition(s_100); -- 99 100rename partition_test to partition_test2;select * from partition_test2 partition(s_80); -- 80select count(*) from partition_test2 partition(s_80); -- 1
经测试, 发现没问题啊!