Create a monthly Partition Table in oracle

Create a monthly Partition Table in oracle

-- Create tablecreate table T_PARTITION_MONTH (FID VARCHAR2 (32) not null, MONTH VARCHAR2 (2) default to_char (sysdate, 'mm'), CREATE_DATE DATE default sysdate) partition by list (MONTH) (partition P01 values ('01') tablespace TBS_DATA pctfree 10 initrans 1 maxtrans 255 storage (initial 64 K next 1 M minextents 1 maxextents unlimited), partition P02 values ('02 ') tablespace TBS_DATA pctfree 10 initrans 1 maxtrans 255 storage (initial 64 K next 1 M minextents 1 maxextents unlimited), partition P03 values ('03 ') tablespace TBS_DATA pctfree 10 initrans 1 maxtrans 255 storage (initial 64 K next 1 M minextents 1 maxextents unlimited), partition P04 values ('04 ') tablespace TBS_DATA pctfree 10 initrans 1 maxtrans 255 storage (initial 64 K next 1 M minextents 1 maxextents unlimited), partition P05 values ('05 ') tablespace TBS_DATA pctfree 10 initrans 1 maxtrans 255 storage (initial 64 K next 1 M minextents 1 maxextents unlimited), partition P06 values ('06 ') tablespace TBS_DATA pctfree 10 initrans 1 maxtrans 255 storage (initial 64 K next 1 M minextents 1 maxextents unlimited), partition P07 values ('07 ') tablespace TBS_DATA pctfree 10 initrans 1 maxtrans 255 storage (initial 64 K next 1 M minextents 1 maxextents unlimited), partition P08 values ('08 ') tablespace TBS_DATA pctfree 10 initrans 1 maxtrans 255 storage (initial 64 K next 1 M minextents 1 maxextents unlimited), partition P09 values ('09 ') tablespace TBS_DATA pctfree 10 initrans 1 maxtrans 255 storage (initial 64 K next 1 M minextents 1 maxextents unlimited), partition P10 values ('10 ') tablespace TBS_DATA pctfree 10 initrans 1 maxtrans 255 storage (initial 64 K next 1 M minextents 1 maxextents unlimited), partition P11 values ('11 ') tablespace TBS_DATA pctfree 10 initrans 1 maxtrans 255 storage (initial 64 K next 1 M minextents 1 maxextents unlimited), partition P12 values ('12 ') tablespace TBS_DATA pctfree 10 initrans 1 maxtrans 255 storage (initial 64 K next 1 M minextents 1 maxextents unlimited); -- Add comments to the table comment on table T_PARTITION_MONTH is 'test 01 '; -- Add comments to the columns comment on column T_PARTITION_MONTH.FID is 'Primary key'; comment on column T_PARTITION_MONTH.MONTH is 'monthly partition field'; comment on column T_PARTITION_MONTH.CREATE_DATE is 'creation time '; -- Create/Recreate primary, unique and foreign key constraints alter table T_PARTITION_MONTH add constraint PK_PARTITION_MONTH primary key (FID) using index tablespace TBS_DATA pctfree 10 initrans 2 maxtrans 255 storage (initial 64 K next 1 M minextents 1 maxextents unlimited );