【SQL开源代码栏目提醒】:网学会员,鉴于大家对SQL开源代码十分关注,论文会员在此为大家搜集整理了“22.4.sql”一文,供大家参考学习!
--
列表分区
CREATE TABLE student
(
student_ID number (4),
student_Name varchar2 (14),
grade varchar2 (15)
)
PARTITION BY LIST (grade)
(
Partition p1 values ('一年级','二年级','三年级','四年级','五年级','六年级')
tablespace users,
Partition p2 values ('初一','初二','初三') tablespace user1,
Partition p3 values ('高一','高二','高三') tablespace bigtbs
);
CREATE TABLE student1
(
student_ID number (4),
student_Name varchar2 (14),
grade varchar2 (15)
)
PARTITION BY LIST (grade)
(
Partition p1 values ('初一','初二','初三') tablespace user1,
Partition p2 values ('高一','高二','高三') tablespace bigtbs,
Partition p3 values (default) tablespace users
);