| 标题 | Oracle建分区表 |
| 内容 | 1、按月创建分区 create table T_MHDP ( ID VARCHAR2(50) not null, FLT_AIRCODE VARCHAR2(4), FLT_NUMBER NUMBER(7), FLT_DATE DATE ) partition by range (FLT_DATE) ( partition PART201105 values less than (TO_DATE(' 2011-06-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) tablespace TS_MHDP_1105 pctfree 10 initrans 1 maxtrans 255 storage ( initial 64K next 1M minextents 1 maxextents unlimited ), partition PART201106 values less than (TO_DATE(' 2011-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) tablespace TS_MHDP_1106 pctfree 10 initrans 1 maxtrans 255 storage ( initial 64K next 1M minextents 1 maxextents unlimited ), partition PART201107 values less than (TO_DATE(' 2011-08-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) tablespace TS_MHDP_1107 pctfree 10 initrans 1 maxtrans 255 storage ( initial 64K next 1M minextents 1 maxextents unlimited ), partition PARTDEFAULT values less than (TO_DATE(' 9999-12-30 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) tablespace TS_MHDP pctfree 10 initrans 1 maxtrans 255 storage ( initial 64K next 1M minextents 1 maxextents unlimited ) ); 2、创建全局索引 create index INDEX_MHDP_PK on T_MHDP(ID) tablespace TS_INDEX_MHDP pctfree 10 initrans 2 maxtrans 255 storage ( initial 64K next 1M minextents 1 maxextents unlimited ); 3、创建本地索引 CREATE INDEX INDEX_MHDP_PK ON T_MHDP(ID) LOCAL ( PARTITION PART201105 TABLESPACE TS_MHDP_INDEX_1105, PARTITION PART201106 TABLESPACE TS_MHDP_INDEX_1106, PARTITION PART201107 TABLESPACE TS_MHDP_INDEX_1107, PARTITION PARTDEFAULT TABLESPACE TS_MHDP_INDEX ); |
| 随便看 |
|
在线学习网考试资料包含高考、自考、专升本考试、人事考试、公务员考试、大学生村官考试、特岗教师招聘考试、事业单位招聘考试、企业人才招聘、银行招聘、教师招聘、农村信用社招聘、各类资格证书考试等各类考试资料。