创建分区表

最新推荐文章于 2024-11-08 14:56:33 发布

zwqq01

最新推荐文章于 2024-11-08 14:56:33 发布

阅读量224

点赞数

分类专栏： oracle 文章标签： less null table

本文链接：https://blog.csdn.net/zwqq01/article/details/5546768

版权

oracle 专栏收录该内容

7 篇文章 0 订阅

订阅专栏

create table CZ_S_JTXXs
(
ITEMNO     NUMBER not null primary key,
AREACODE   VARCHAR2(12) not null,
PCODE      VARCHAR2(40) not null,
HCODE      VARCHAR2(30) not null,
HKXZ       NUMBER,
PHONE      VARCHAR2(30),
ADDRESS    VARCHAR2(100),
ZIPCARD    VARCHAR2(100),
MEMO       VARCHAR2(100),
FLAG       NUMBER(1) default 1 not null,
locations number not null
)partition by range(locations)
(
partition part1 values less than (2) tablespace sl1,
partition part2 values less than (3) tablespace sl2,
partition part3 values less than (4) tablespace sl3,
partition part4 values less than (5) tablespace sl4,
partition part5 values less than (6) tablespace sl5,
partition part6 values less than (7) tablespace sl6,
partition part7 values less than (8) tablespace sl7,
partition part8 values less than (9) tablespace sl8,
partition part9 values less than (10) tablespace sl9,
partition part10 values less than (11) tablespace sl10,
partition part11 values less than (12) tablespace sl11,
partition part12 values less than (maxvalue) tablespace sl12
)