create table table_name
(
STAT_DATE DATE,
.........
一下字段省略
)
partition by (STAT_DATE)
(
partition PARTITION01
tablespace a
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 160K
minextents 1
maxextents unlimited
),
partition PARTITION02
tablespace a
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 160K
minextents 1
maxextents unlimited
),
partition PARTITION03
tablespace a
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 160K
minextents 1
maxextents unlimited
),
partition PARTITION04
tablespace a
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 160K
minextents 1
maxextents unlimited
),
partition PARTITION05
tablespace a
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 160K
minextents 1
maxextents unlimited
),
partition PARTITION06
tablespace a
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 160K
minextents 1
maxextents unlimited
),
partition PARTITION07
tablespace a
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 160K
minextents 1
maxextents unlimited
),
partition PARTITION08
tablespace a
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 160K
minextents 1
maxextents unlimited
),
partition PARTITION09
tablespace a
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 160K
minextents 1
maxextents unlimited
),
partition PARTITION10
tablespace a
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 160K
minextents 1
maxextents unlimited
),
partition PARTITION11
tablespace a
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 160K
minextents 1
maxextents unlimited
),
partition PARTITION12
tablespace a
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 160K
minextents 1
maxextents unlimited
),
partition PARTITION13
tablespace a
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 160K
minextents 1
maxextents unlimited
)
)刚刚学习分区,不知道这属于哪一种分区方式,我看了介绍oracle的几种,都没有这种方式,请高手指点下
(
STAT_DATE DATE,
.........
一下字段省略
)
partition by (STAT_DATE)
(
partition PARTITION01
tablespace a
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 160K
minextents 1
maxextents unlimited
),
partition PARTITION02
tablespace a
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 160K
minextents 1
maxextents unlimited
),
partition PARTITION03
tablespace a
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 160K
minextents 1
maxextents unlimited
),
partition PARTITION04
tablespace a
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 160K
minextents 1
maxextents unlimited
),
partition PARTITION05
tablespace a
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 160K
minextents 1
maxextents unlimited
),
partition PARTITION06
tablespace a
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 160K
minextents 1
maxextents unlimited
),
partition PARTITION07
tablespace a
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 160K
minextents 1
maxextents unlimited
),
partition PARTITION08
tablespace a
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 160K
minextents 1
maxextents unlimited
),
partition PARTITION09
tablespace a
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 160K
minextents 1
maxextents unlimited
),
partition PARTITION10
tablespace a
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 160K
minextents 1
maxextents unlimited
),
partition PARTITION11
tablespace a
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 160K
minextents 1
maxextents unlimited
),
partition PARTITION12
tablespace a
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 160K
minextents 1
maxextents unlimited
),
partition PARTITION13
tablespace a
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 160K
minextents 1
maxextents unlimited
)
)刚刚学习分区,不知道这属于哪一种分区方式,我看了介绍oracle的几种,都没有这种方式,请高手指点下
select dbms_metadata.get_ddl('TABLE', 'TABLE_NAME', 'SCOTT') from dual;
用这个就可以知道是怎么分的了,谢谢上面的回答了!