查看表分区:
SELECT * FROM USER_TAB_PARTITIONS WHERE TABLE_NAME='tb';
增加分区:
ALTER TABLE 'tb' ADD PARTITION "P20180702" VALUES LESS THAN ('20180702') TABLESPACE "CACHETBS"
查看表分区:
SELECT * FROM USER_TAB_PARTITIONS WHERE TABLE_NAME='tb';
增加分区:
ALTER TABLE 'tb' ADD PARTITION "P20180702" VALUES LESS THAN ('20180702') TABLESPACE "CACHETBS"