【SQL开源代码栏目提醒】:网学会员鉴于大家对SQL开源代码十分关注,论文会员在此为大家搜集整理了“22.6.1.sql”一文,供大家参考学习
--
系统分区
CREATE TABLE systab (c1 integer, c2 integer)
PARTITION BY SYSTEM
(
PARTITION p1,
PARTITION p2,
PARTITION p3,
PARTITION p4
);
INSERT INTO systab VALUES (4,5);
INSERT INTO systab PARTITION (p2) VALUES (4,5); /* partition p2 */
INSERT INTO systab PARTITION (2) VALUES (4,5) /* second partition */
INSERT INTO systab PARTITION (:pno) VALUES (4,5); /* pno bound to 1/p1 */
select partition_name,high_value from user_tab_partitions
where table_name='SYSTAB';
select partitioning_type from user_part_tables
where table_name = 'SYSTAB';