我创建了一个表,里面要加入分区语句,分区语句我已经查到了,但不知道怎么写入
创建语句摘取如下:
create table ACTTXN
(
ACCTNUM VARCHAR2(14) not null,
AFF_COM NUMBER(20,4),
MSG_TYPE VARCHAR2(3),
SOURCE NUMBER not null,
TERM_ID VARCHAR2(10),
REC_SEQ NUMBER,
TXNROUTE NUMBER,
TXNCODE VARCHAR2(3) not null,
TXNSTAT NUMBER not null,
STATREAS VARCHAR2(15),
TRACE NUMBER,
......
);原先没有分区,我现在要加入如下分区语句,怎么写入呀?
在创建的表中建立分区呀?急求帮忙,谢谢了!
partition by range (POSTDATE)
(
partition ACTTXN_200801 values less than (TO_DATE(' 2008-02-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
tablespace ACTTXN_ITXN
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
),
partition ACTTXN_200802 values less than (TO_DATE(' 2008-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
tablespace ACTTXN_ITXN
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
)
创建语句摘取如下:
create table ACTTXN
(
ACCTNUM VARCHAR2(14) not null,
AFF_COM NUMBER(20,4),
MSG_TYPE VARCHAR2(3),
SOURCE NUMBER not null,
TERM_ID VARCHAR2(10),
REC_SEQ NUMBER,
TXNROUTE NUMBER,
TXNCODE VARCHAR2(3) not null,
TXNSTAT NUMBER not null,
STATREAS VARCHAR2(15),
TRACE NUMBER,
......
);原先没有分区,我现在要加入如下分区语句,怎么写入呀?
在创建的表中建立分区呀?急求帮忙,谢谢了!
partition by range (POSTDATE)
(
partition ACTTXN_200801 values less than (TO_DATE(' 2008-02-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
tablespace ACTTXN_ITXN
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
),
partition ACTTXN_200802 values less than (TO_DATE(' 2008-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
tablespace ACTTXN_ITXN
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
)
(
ACCTNUM VARCHAR2(14) not null,
AFF_COM NUMBER(20,4),
MSG_TYPE VARCHAR2(3),
SOURCE NUMBER not null,
TERM_ID VARCHAR2(10),
REC_SEQ NUMBER,
TXNROUTE NUMBER,
TXNCODE VARCHAR2(3) not null,
TXNSTAT NUMBER not null,
STATREAS VARCHAR2(15),
TRACE NUMBER,
......
)
我创建了一个表,里面要加入分区语句,分区语句我已经查到了,但不知道怎么写入
创建语句摘取如下:
create table ACTTXN
(
ACCTNUM VARCHAR2(14) not null,
AFF_COM NUMBER(20,4),
MSG_TYPE VARCHAR2(3),
SOURCE NUMBER not null,
TERM_ID VARCHAR2(10),
REC_SEQ NUMBER,
TXNROUTE NUMBER,
TXNCODE VARCHAR2(3) not null,
TXNSTAT NUMBER not null,
STATREAS VARCHAR2(15),
TRACE NUMBER,
......
);原先没有分区,我现在要加入如下分区语句,怎么写入呀?
在创建的表中建立分区呀?急求帮忙,谢谢了!
partition by range (POSTDATE)
(
partition ACTTXN_200801 values less than (TO_DATE(' 2008-02-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
tablespace ACTTXN_ITXN
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
),
partition ACTTXN_200802 values less than (TO_DATE(' 2008-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
tablespace ACTTXN_ITXN
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
)
);
(
ACCTNUM VARCHAR2(14) not null,
AFF_COM NUMBER(20,4),
MSG_TYPE VARCHAR2(3),
SOURCE NUMBER not null,
TERM_ID VARCHAR2(10),
REC_SEQ NUMBER,
TXNROUTE NUMBER,
TXNCODE VARCHAR2(3) not null,
TXNSTAT NUMBER not null,
STATREAS VARCHAR2(15),
TRACE NUMBER,
......
)
partition by range (POSTDATE)
(
partition ACTTXN_200801 values less than (TO_DATE(' 2008-02-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
tablespace ACTTXN_ITXN
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
),
partition ACTTXN_200802 values less than (TO_DATE(' 2008-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
tablespace ACTTXN_ITXN
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
));