partition table HDDPI_WBL_MTR2

SQL> CREATE TABLE HDDPI_WBL_MTR2 (
2 PWM_WBL_NUM VARCHAR2(13),
3 PWM_RGT_STS VARCHAR2(1),
4 PWM_RGT_MDH DATE,
5 PWM_RGT_ORG VARCHAR2(7),
6 PWM_RGT_CUN VARCHAR2(7),
7 PWM_RGT_ENO VARCHAR2(7),
8 PWM_NOW_STA VARCHAR2(2),
9 PWM_NOW_ORG VARCHAR2(7),
10 PWM_RSN_COD VARCHAR2(2),
11 PWM_ENP_DIV VARCHAR2(1),
12 PWM_GOD_COD VARCHAR2(3),
13 PWM_GOD_NAM VARCHAR2(50),
14 PWM_QTY NUMBER(4,0) DEFAULT 0,
15 PWM_GOD_PRC NUMBER(9,2) DEFAULT 0,
16 PWM_GOD_CUR VARCHAR2(3),
17 PWM_PAY_CON VARCHAR2(2),
18 PWM_ATH_NUM NUMBER(3,0),
19 PWM_TRN_FRE NUMBER(11,2) DEFAULT 0,
20 PWM_PAK_FRE NUMBER(9,2) DEFAULT 0,
21 PWM_EXT_FRE NUMBER(9,2) DEFAULT 0,
22 PWM_ETC_FRE NUMBER(9,2) DEFAULT 0,
23 PWM_SND_NUM VARCHAR2(7),
24 PWM_SND_NAM VARCHAR2(50),
25 PWM_SND_CRG VARCHAR2(20),
26 PWM_SND_TEL VARCHAR2(15),
27 PWM_SND_ZIP VARCHAR2(6),
28 PWM_SND_ADD VARCHAR2(50),
29 PWM_RCV_NUM VARCHAR2(7),
30 PWM_RCV_NAM VARCHAR2(50),
31 PWM_RCV_CRG VARCHAR2(20),
32 PWM_RCV_TEL VARCHAR2(15),
33 PWM_RCV_ZIP VARCHAR2(6),
34 PWM_RCV_ADD VARCHAR2(50),
35 PWM_ACP_CTR VARCHAR2(7),
36 PWM_PIC_COD VARCHAR2(7),
37 PWM_PIC_PDZ VARCHAR2(7),
38 PWM_DLV_COD VARCHAR2(7),
39 PWM_DLV_PDZ VARCHAR2(7),
40 PWM_DML_COD VARCHAR2(7),
41 PWM_AML_COD VARCHAR2(7),
42 PWM_PND_YMD VARCHAR2(8),
43 PWM_PES_ENO VARCHAR2(7),
44 PWM_DLV_YMD VARCHAR2(8),
45 PWM_FDN_YMD VARCHAR2(8),
46 PWM_DES_ENO VARCHAR2(7),
47 PWM_SDN_YMD VARCHAR2(8),
48 PWM_SDN_CUN VARCHAR2(7),
49 PWM_INC_ENO VARCHAR2(7),
50 PWM_RCT_NAM VARCHAR2(20),
51 PWM_CLM_YMD VARCHAR2(8),
52 PWM_TXC_NUM VARCHAR2(11),
53 PWM_RCM_TAB VARCHAR2(8),
54 PWM_SND_FNO VARCHAR2(30),
55 PWM_REQ_NUM VARCHAR2(7),
56 PWM_RSV_NUM VARCHAR2(9),
57 PWM_DMB_NUM VARCHAR2(14),
58 PWM_DCT_NUM VARCHAR2(10),
59 PWM_PDL_YN VARCHAR2(1),
60 PWM_ABN_YN VARCHAR2(1),
61 PWM_RBL_NUM VARCHAR2(13),
62 PWM_SND_PRV VARCHAR2(15),
63 PWM_SND_CIT VARCHAR2(15),
64 PWM_SND_FST VARCHAR2(50),
65 PWM_RCV_PRV VARCHAR2(15),
66 PWM_RCV_CIT VARCHAR2(15),
67 PWM_RCV_FST VARCHAR2(50),
68 PWM_DGR_YMD VARCHAR2(8),
69 PWM_DGR_SEQ NUMBER(2,0),
70 PWM_INV_NO1 VARCHAR2(12),
71 PWM_INV_NO2 VARCHAR2(12),
72 PWM_INV_NO3 VARCHAR2(12),
73 PWM_DSK_YMD VARCHAR2(8) DEFAULT to_char(SYSDATE,'MMDDYYYY') NOT NULL ENABLE,
74 PWM_WRK_YMD VARCHAR2(8),
75 PWM_WRK_DIV VARCHAR2(1),
76 PWM_SHP_ID VARCHAR2(8),
77 PWM_EDI_COD VARCHAR2(8),
78 PWM_DNC_ENO VARCHAR2(7),
79 PWM_NRP_SEQ NUMBER(2,0),
80 PWM_NRP_GBN VARCHAR2(2),
81 PWM_BIL_CFM VARCHAR2(1),
82 PWM_COD_FEE NUMBER(9,2),
83 CONSTRAINT PK_HDDPI_WBL_MTR2 PRIMARY KEY (PWM_WBL_NUM) USING INDEX TABLESPACE TS_AA_WBL_MTR_ORG_I
84 )
85 partition by range (PWM_PND_YMD) (
86 partition part_mtr_d0000 values less than ('19991299') tablespace TS_AA_WBL_MTR_ORG_D,
87 partition part_mtr_d0001 values less than ('20000199') tablespace TS_AA_WBL_MTR_ORG_D,
88 partition part_mtr_d0002 values less than ('20000299') tablespace TS_AA_WBL_MTR_ORG_D,
89 partition part_mtr_d0003 values less than ('20000399') tablespace TS_AA_WBL_MTR_ORG_D,
90 partition part_mtr_d0004 values less than ('20000499') tablespace TS_AA_WBL_MTR_ORG_D,
91 partition part_mtr_d0005 values less than ('20000599') tablespace TS_AA_WBL_MTR_ORG_D,
92 partition part_mtr_d0006 values less than ('20000699') tablespace TS_AA_WBL_MTR_ORG_D,
93 partition part_mtr_d0007 values less than ('20000799') tablespace TS_AA_WBL_MTR_ORG_D,
94 partition part_mtr_d0008 values less than ('20000899') tablespace TS_AA_WBL_MTR_ORG_D,
95 partition part_mtr_d0009 values less than ('20000999') tablespace TS_AA_WBL_MTR_ORG_D,
96 partition part_mtr_d0010 values less than ('20001099') tablespace TS_AA_WBL_MTR_ORG_D,
97 partition part_mtr_d0011 values less than ('20001199') tablespace TS_AA_WBL_MTR_ORG_D,
98 partition part_mtr_d0012 values less than ('20001299') tablespace TS_AA_WBL_MTR_ORG_D,
99 partition part_mtr_d0101 values less than ('20010199') tablespace TS_AA_WBL_MTR_ORG_D,
100 partition part_mtr_d0102 values less than ('20010299') tablespace TS_AA_WBL_MTR_ORG_D,
101 partition part_mtr_d0103 values less than ('20010399') tablespace TS_AA_WBL_MTR_ORG_D,
102 partition part_mtr_d0104 values less than ('20010499') tablespace TS_AA_WBL_MTR_ORG_D,
103 partition part_mtr_d0105 values less than ('20010599') tablespace TS_AA_WBL_MTR_ORG_D,
104 partition part_mtr_d0106 values less than ('20010699') tablespace TS_AA_WBL_MTR_ORG_D,
105 partition part_mtr_d0107 values less than ('20010799') tablespace TS_AA_WBL_MTR_ORG_D,
106 partition part_mtr_d0108 values less than ('20010899') tablespace TS_AA_WBL_MTR_ORG_D,
107 partition part_mtr_d0109 values less than ('20010999') tablespace TS_AA_WBL_MTR_ORG_D,
108 partition part_mtr_d0110 values less than ('20011099') tablespace TS_AA_WBL_MTR_ORG_D,
109 partition part_mtr_d0111 values less than ('20011199') tablespace TS_AA_WBL_MTR_ORG_D,
110 partition part_mtr_d0112 values less than ('20011299') tablespace TS_AA_WBL_MTR_ORG_D,
111 partition part_mtr_d0201 values less than ('20020199') tablespace TS_AA_WBL_MTR_ORG_D,
112 partition part_mtr_d0202 values less than ('20020299') tablespace TS_AA_WBL_MTR_ORG_D,
113 partition part_mtr_d0203 values less than ('20020399') tablespace TS_AA_WBL_MTR_ORG_D,
114 partition part_mtr_d0204 values less than ('20020499') tablespace TS_AA_WBL_MTR_ORG_D,
115 partition part_mtr_d0205 values less than ('20020599') tablespace TS_AA_WBL_MTR_ORG_D,
116 partition part_mtr_d0206 values less than ('20020699') tablespace TS_AA_WBL_MTR_ORG_D,
117 partition part_mtr_d0207 values less than ('20020799') tablespace TS_AA_WBL_MTR_ORG_D,
118 partition part_mtr_d0208 values less than ('20020899') tablespace TS_AA_WBL_MTR_ORG_D,
119 partition part_mtr_d0209 values less than ('20020999') tablespace TS_AA_WBL_MTR_ORG_D,
120 partition part_mtr_d0210 values less than ('20021099') tablespace TS_AA_WBL_MTR_ORG_D,
121 partition part_mtr_d0211 values less than ('20021199') tablespace TS_AA_WBL_MTR_ORG_D,
122 partition part_mtr_d0212 values less than ('20021299') tablespace TS_AA_WBL_MTR_ORG_D,
123 partition part_mtr_d0301 values less than ('20030199') tablespace TS_AA_WBL_MTR_ORG_D,
124 partition part_mtr_d0302 values less than ('20030299') tablespace TS_AA_WBL_MTR_ORG_D,
125 partition part_mtr_d0303 values less than ('20030399') tablespace TS_AA_WBL_MTR_ORG_D,
126 partition part_mtr_d0304 values less than ('20030499') tablespace TS_AA_WBL_MTR_ORG_D,
127 partition part_mtr_d0305 values less than ('20030599') tablespace TS_AA_WBL_MTR_ORG_D,
128 partition part_mtr_d0306 values less than ('20030699') tablespace TS_AA_WBL_MTR_ORG_D,
129 partition part_mtr_d0307 values less than ('20030799') tablespace TS_AA_WBL_MTR_ORG_D,
130 partition part_mtr_d0308 values less than ('20030899') tablespace TS_AA_WBL_MTR_ORG_D,
131 partition part_mtr_d0309 values less than ('20030999') tablespace TS_AA_WBL_MTR_ORG_D,
132 partition part_mtr_d0310 values less than ('20031099') tablespace TS_AA_WBL_MTR_ORG_D,
133 partition part_mtr_d0311 values less than ('20031199') tablespace TS_AA_WBL_MTR_ORG_D,
134 partition part_mtr_d0312 values less than ('20031299') tablespace TS_AA_WBL_MTR_ORG_D,
135 partition part_mtr_d0401 values less than ('20040199') tablespace TS_AA_WBL_MTR_ORG_D,
136 partition part_mtr_d0402 values less than ('20040299') tablespace TS_AA_WBL_MTR_ORG_D,
137 partition part_mtr_d0403 values less than ('20040399') tablespace TS_AA_WBL_MTR_ORG_D,
138 partition part_mtr_d0404 values less than ('20040499') tablespace TS_AA_WBL_MTR_ORG_D,
139 partition part_mtr_d0405 values less than ('20040599') tablespace TS_AA_WBL_MTR_ORG_D,
140 partition part_mtr_d0406 values less than ('20040699') tablespace TS_AA_WBL_MTR_ORG_D,
141 partition part_mtr_d0407 values less than ('20040799') tablespace TS_AA_WBL_MTR_ORG_D,
142 partition part_mtr_d0408 values less than ('20040899') tablespace TS_AA_WBL_MTR_ORG_D,
143 partition part_mtr_d0409 values less than ('20040999') tablespace TS_AA_WBL_MTR_ORG_D,
144 partition part_mtr_d0410 values less than ('20041099') tablespace TS_AA_WBL_MTR_ORG_D,
145 partition part_mtr_d0411 values less than ('20041199') tablespace TS_AA_WBL_MTR_ORG_D,
146 partition part_mtr_d0412 values less than ('20041299') tablespace TS_AA_WBL_MTR_ORG_D,
147 partition part_mtr_d0501 values less than ('20050199') tablespace TS_AA_WBL_MTR_ORG_D,
148 partition part_mtr_d0502 values less than ('20050299') tablespace TS_AA_WBL_MTR_ORG_D,
149 partition part_mtr_d0503 values less than ('20050399') tablespace TS_AA_WBL_MTR_ORG_D,
150 partition part_mtr_d0504 values less than ('20050499') tablespace TS_AA_WBL_MTR_ORG_D,
151 partition part_mtr_d0505 values less than ('20050599') tablespace TS_AA_WBL_MTR_ORG_D,
152 partition part_mtr_d0506 values less than ('20050699') tablespace TS_AA_WBL_MTR_ORG_D,
153 partition part_mtr_d0507 values less than ('20050799') tablespace TS_AA_WBL_MTR_ORG_D,
154 partition part_mtr_d0508 values less than ('20050899') tablespace TS_AA_WBL_MTR_ORG_D,
155 partition part_mtr_d0509 values less than ('20050999') tablespace TS_AA_WBL_MTR_ORG_D,
156 partition part_mtr_d0510 values less than ('20051099') tablespace TS_AA_WBL_MTR_ORG_D,
157 partition part_mtr_d0511 values less than ('20051199') tablespace TS_AA_WBL_MTR_ORG_D,
158 partition part_mtr_d0512 values less than ('20051299') tablespace TS_AA_WBL_MTR_ORG_D,
159 partition part_mtr_d0601 values less than ('20060199') tablespace TS_AA_WBL_MTR_ORG_D,
160 partition part_mtr_d0602 values less than ('20060299') tablespace TS_AA_WBL_MTR_ORG_D,
161 partition part_mtr_d0603 values less than ('20060399') tablespace TS_AA_WBL_MTR_ORG_D,
162 partition part_mtr_d0604 values less than ('20060499') tablespace TS_AA_WBL_MTR_ORG_D,
163 partition part_mtr_d0605 values less than ('20060599') tablespace TS_AA_WBL_MTR_ORG_D,
164 partition part_mtr_d0606 values less than ('20060699') tablespace TS_AA_WBL_MTR_ORG_D,
165 partition part_mtr_d0607 values less than ('20060799') tablespace TS_AA_WBL_MTR_ORG_D,
166 partition part_mtr_d0608 values less than ('20060899') tablespace TS_AA_WBL_MTR_ORG_D,
167 partition part_mtr_d0609 values less than ('20060999') tablespace TS_AA_WBL_MTR_ORG_D,
168 partition part_mtr_d0610 values less than ('20061099') tablespace TS_AA_WBL_MTR_ORG_D,
169 partition part_mtr_d0611 values less than ('20061199') tablespace TS_AA_WBL_MTR_ORG_D,
170 partition part_mtr_d0612 values less than ('20061299') tablespace TS_AA_WBL_MTR_ORG_D,
171 partition part_mtr_d0701 values less than ('20070199') tablespace TS_AA_WBL_MTR_ORG_D,
172 partition part_mtr_d0702 values less than ('20070299') tablespace TS_AA_WBL_MTR_ORG_D,
173 partition part_mtr_d0703 values less than ('20070399') tablespace TS_AA_WBL_MTR_ORG_D,
174 partition part_mtr_d0704 values less than ('20070499') tablespace TS_AA_WBL_MTR_ORG_D,
175 partition part_mtr_d0705 values less than ('20070599') tablespace TS_AA_WBL_MTR_ORG_D,
176 partition part_mtr_d0706 values less than ('20070699') tablespace TS_AA_WBL_MTR_ORG_D,
177 partition part_mtr_d0707 values less than ('20070799') tablespace TS_AA_WBL_MTR_ORG_D,
178 partition part_mtr_d0708 values less than ('20070899') tablespace TS_AA_WBL_MTR_ORG_D,
179 partition part_mtr_d0709 values less than ('20070999') tablespace TS_AA_WBL_MTR_ORG_D,
180 partition part_mtr_d0710 values less than ('20071099') tablespace TS_AA_WBL_MTR_ORG_D,
181 partition part_mtr_d0711 values less than ('20071199') tablespace TS_AA_WBL_MTR_ORG_D,
182 partition part_mtr_d0712 values less than ('20071299') tablespace TS_AA_WBL_MTR_ORG_D,
183 partition part_mtr_d0801 values less than ('20080199') tablespace TS_AA_WBL_MTR_ORG_D,
184 partition part_mtr_d0802 values less than ('20080299') tablespace TS_AA_WBL_MTR_ORG_D,
185 partition part_mtr_d0803 values less than ('20080399') tablespace TS_AA_WBL_MTR_ORG_D,
186 partition part_mtr_d0804 values less than ('20080499') tablespace TS_AA_WBL_MTR_ORG_D,
187 partition part_mtr_d0805 values less than ('20080599') tablespace TS_AA_WBL_MTR_ORG_D,
188 partition part_mtr_d0806 values less than ('20080699') tablespace TS_AA_WBL_MTR_ORG_D,
189 partition part_mtr_d0807 values less than ('20080799') tablespace TS_AA_WBL_MTR_ORG_D,
190 partition part_mtr_d0808 values less than ('20080899') tablespace TS_AA_WBL_MTR_ORG_D,
191 partition part_mtr_d0809 values less than ('20080999') tablespace TS_AA_WBL_MTR_ORG_D,
192 partition part_mtr_d0810 values less than ('20081099') tablespace TS_AA_WBL_MTR_ORG_D,
193 partition part_mtr_d0811 values less than ('20081199') tablespace TS_AA_WBL_MTR_ORG_D,
194 partition part_mtr_d0812 values less than ('20081299') tablespace TS_AA_WBL_MTR_ORG_D,
195 partition part_mtr_d0901 values less than ('20090199') tablespace TS_AA_WBL_MTR_ORG_D,
196 partition part_mtr_d0902 values less than ('20090299') tablespace TS_AA_WBL_MTR_ORG_D,
197 partition part_mtr_d0903 values less than ('20090399') tablespace TS_AA_WBL_MTR_ORG_D,
198 partition part_mtr_d0904 values less than ('20090499') tablespace TS_AA_WBL_MTR_ORG_D,
199 partition part_mtr_d0905 values less than ('20090599') tablespace TS_AA_WBL_MTR_ORG_D,
200 partition part_mtr_d0906 values less than ('20090699') tablespace TS_AA_WBL_MTR_ORG_D,
201 partition part_mtr_d0907 values less than ('20090799') tablespace TS_AA_WBL_MTR_ORG_D,
202 partition part_mtr_d0908 values less than ('20090899') tablespace TS_AA_WBL_MTR_ORG_D,
203 partition part_mtr_d0909 values less than ('20090999') tablespace TS_AA_WBL_MTR_ORG_D,
204 partition part_mtr_d0910 values less than ('20091099') tablespace TS_AA_WBL_MTR_ORG_D,
205 partition part_mtr_d0911 values less than ('20091199') tablespace TS_AA_WBL_MTR_ORG_D,
206 partition part_mtr_d0912 values less than ('20091299') tablespace TS_AA_WBL_MTR_ORG_D,
207 partition part_mtr_d9999 values less than (maxvalue) tablespace TS_AA_WBL_MTR_ORG_D
208 ) ;

Table created.

Elapsed: 00:00:00.32
SQL> alter table hddpi_wbl_mtr2 nologging;

Table altered.

Elapsed: 00:00:00.06
SQL> alter index pk_hddpi_wbl_mtr2 nologging;

Index altered.

Elapsed: 00:00:00.00
SQL> set transaction use rollback segment r01;

Transaction set.

Elapsed: 00:00:00.00
SQL> select count(*) from hddpi_wbl_mtr2;

COUNT(*)
----------
0

Elapsed: 00:00:02.88
SQL> insert /*+ APPEND */ into hddpi_wbl_mtr2 select * from hddpi_wbl_mtr;

72552367 rows created.

Elapsed: 01:13:42.25
SQL> commit;

Commit complete.

Elapsed: 00:00:00.23
SQL> select count(*) from hddpi_wbl_mtr2 partition (part_mtr_d9999);

COUNT(*)
----------
30887

Elapsed: 00:00:00.13
SQL> select count(*) from hddpi_wbl_mtr2 partition (part_mtr_d0000);

COUNT(*)
----------
913

Elapsed: 00:00:00.03
SQL> select count(*) from hddpi_wbl_mtr2 partition (part_mtr_d0001);

COUNT(*)
----------
373

Elapsed: 00:00:00.03