palsplitpartition/ATTRIB_MDAY_YN_VAL_DSOS_2019.SQL at master · xueyubingsen/palsplitpartition · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
ALTER TABLE ATTRIB_MDAY_YN_VAL_DSOS SPLIT PARTITION AM_YN_VAL_DSOS_MAXX AT (2018) INTO
(PARTITION AM_YN_VAL_DSOS_2017 TABLESPACE RDC_DSOS_01, PARTITION AM_YN_VAL_DSOS_MAXX TABLESPACE RDC_DSOS_01);

begin
  for csr in
  (
  select partition_name,
  'ALTER TABLE ATTRIB_MDAY_YN_VAL_DSOS RENAME SUBPARTITION '|| SUBPARTITION_NAME||' TO ' ||partition_name||'P'||lpad(rownum,2,'0') cmd
  from user_tab_subpartitions
  where table_name = 'ATTRIB_MDAY_YN_VAL_DSOS'
  and partition_name like '%2017'
  order by subpartition_position
  )
  loop
    execute immediate csr.cmd;
  end loop;
end;
/

ALTER TABLE ATTRIB_MDAY_YN_VAL_DSOS MOVE SUBPARTITION AM_YN_VAL_DSOS_2017P01 TABLESPACE RDC_DSOS_01;
ALTER TABLE ATTRIB_MDAY_YN_VAL_DSOS MOVE SUBPARTITION AM_YN_VAL_DSOS_2017P02 TABLESPACE RDC_DSOS_02;
ALTER TABLE ATTRIB_MDAY_YN_VAL_DSOS MOVE SUBPARTITION AM_YN_VAL_DSOS_2017P03 TABLESPACE RDC_DSOS_03;
ALTER TABLE ATTRIB_MDAY_YN_VAL_DSOS MOVE SUBPARTITION AM_YN_VAL_DSOS_2017P04 TABLESPACE RDC_DSOS_04;
ALTER TABLE ATTRIB_MDAY_YN_VAL_DSOS MOVE SUBPARTITION AM_YN_VAL_DSOS_2017P05 TABLESPACE RDC_DSOS_01;
ALTER TABLE ATTRIB_MDAY_YN_VAL_DSOS MOVE SUBPARTITION AM_YN_VAL_DSOS_2017P06 TABLESPACE RDC_DSOS_02;
ALTER TABLE ATTRIB_MDAY_YN_VAL_DSOS MOVE SUBPARTITION AM_YN_VAL_DSOS_2017P07 TABLESPACE RDC_DSOS_03;
ALTER TABLE ATTRIB_MDAY_YN_VAL_DSOS MOVE SUBPARTITION AM_YN_VAL_DSOS_2017P08 TABLESPACE RDC_DSOS_04;
ALTER TABLE ATTRIB_MDAY_YN_VAL_DSOS MOVE SUBPARTITION AM_YN_VAL_DSOS_2017P09 TABLESPACE RDC_DSOS_01;
ALTER TABLE ATTRIB_MDAY_YN_VAL_DSOS MOVE SUBPARTITION AM_YN_VAL_DSOS_2017P10 TABLESPACE RDC_DSOS_02;
ALTER TABLE ATTRIB_MDAY_YN_VAL_DSOS MOVE SUBPARTITION AM_YN_VAL_DSOS_2017P11 TABLESPACE RDC_DSOS_03;
ALTER TABLE ATTRIB_MDAY_YN_VAL_DSOS MOVE SUBPARTITION AM_YN_VAL_DSOS_2017P12 TABLESPACE RDC_DSOS_04;

begin
  for csr in
  (
  select partition_name,
  SUBPARTITION_NAME,
  'ALTER INDEX '|| index_name||' RENAME SUBPARTITION '|| SUBPARTITION_NAME||' TO ' ||partition_name||'P'||lpad(rownum,2,'0') cmd
  from user_ind_subpartitions
  where index_name = 'IDX_ATTRIB_MYN_DSOS_ATDEF'
  and partition_name like '%2017'
  order by index_name, subpartition_position
  )
  loop
    execute immediate csr.cmd;
  end loop;
end;
/

begin
  for csr in
  (
  select partition_name,
  SUBPARTITION_NAME,
  'ALTER INDEX '|| index_name||' RENAME SUBPARTITION '|| SUBPARTITION_NAME||' TO ' ||partition_name||'P'||lpad(rownum,2,'0') cmd
  from user_ind_subpartitions
  where index_name = 'PK_ATTRIB_MDAY_YN_VAL_DSOS'
  and partition_name like '%2017'
  order by index_name, subpartition_position
  )
  loop
    execute immediate csr.cmd;
  end loop;
end;
/

ALTER INDEX PK_ATTRIB_MDAY_YN_VAL_DSOS MODIFY DEFAULT ATTRIBUTES FOR PARTITION AM_YN_VAL_DSOS_2017 TABLESPACE RDC_DSOS_IDX_01 STORAGE (INITIAL 20971520 NEXT 41943040 FREELISTS 4 FREELIST GROUPS 2);
ALTER INDEX PK_ATTRIB_MDAY_YN_VAL_DSOS MODIFY DEFAULT ATTRIBUTES FOR PARTITION AM_YN_VAL_DSOS_MAXX TABLESPACE RDC_DSOS_IDX_01 STORAGE (INITIAL 20971520 NEXT 41943040 FREELISTS 4 FREELIST GROUPS 2);
ALTER INDEX IDX_ATTRIB_MYN_DSOS_ATDEF MODIFY DEFAULT ATTRIBUTES FOR PARTITION AM_YN_VAL_DSOS_2017 TABLESPACE RDC_DSOS_IDX_01 STORAGE (INITIAL 20971520 NEXT 41943040 FREELISTS 4 FREELIST GROUPS 2);
ALTER INDEX IDX_ATTRIB_MYN_DSOS_ATDEF MODIFY DEFAULT ATTRIBUTES FOR PARTITION AM_YN_VAL_DSOS_MAXX TABLESPACE RDC_DSOS_IDX_01 STORAGE (INITIAL 20971520 NEXT 41943040 FREELISTS 4 FREELIST GROUPS 2);

---
ALTER TABLE ATTRIB_MDAY_YN_VAL_DSOS SPLIT PARTITION AM_YN_VAL_DSOS_2017 AT (2017) INTO
(PARTITION AM_YN_VAL_DSOS_2016 TABLESPACE RDC_DSOS_01, PARTITION AM_YN_VAL_DSOS_2017 TABLESPACE RDC_DSOS_01);

begin
  for csr in
  (
  select partition_name,
  'ALTER TABLE ATTRIB_MDAY_YN_VAL_DSOS RENAME SUBPARTITION '|| SUBPARTITION_NAME||' TO ' ||partition_name||'P'||lpad(rownum,2,'0') cmd
  from user_tab_subpartitions
  where table_name = 'ATTRIB_MDAY_YN_VAL_DSOS'
  and partition_name like '%2016'
  order by subpartition_position
  )
  loop
    execute immediate csr.cmd;
  end loop;
end;
/

ALTER TABLE ATTRIB_MDAY_YN_VAL_DSOS MOVE SUBPARTITION AM_YN_VAL_DSOS_2016P01 TABLESPACE RDC_DSOS_01;
ALTER TABLE ATTRIB_MDAY_YN_VAL_DSOS MOVE SUBPARTITION AM_YN_VAL_DSOS_2016P02 TABLESPACE RDC_DSOS_02;
ALTER TABLE ATTRIB_MDAY_YN_VAL_DSOS MOVE SUBPARTITION AM_YN_VAL_DSOS_2016P03 TABLESPACE RDC_DSOS_03;
ALTER TABLE ATTRIB_MDAY_YN_VAL_DSOS MOVE SUBPARTITION AM_YN_VAL_DSOS_2016P04 TABLESPACE RDC_DSOS_04;
ALTER TABLE ATTRIB_MDAY_YN_VAL_DSOS MOVE SUBPARTITION AM_YN_VAL_DSOS_2016P05 TABLESPACE RDC_DSOS_01;
ALTER TABLE ATTRIB_MDAY_YN_VAL_DSOS MOVE SUBPARTITION AM_YN_VAL_DSOS_2016P06 TABLESPACE RDC_DSOS_02;
ALTER TABLE ATTRIB_MDAY_YN_VAL_DSOS MOVE SUBPARTITION AM_YN_VAL_DSOS_2016P07 TABLESPACE RDC_DSOS_03;
ALTER TABLE ATTRIB_MDAY_YN_VAL_DSOS MOVE SUBPARTITION AM_YN_VAL_DSOS_2016P08 TABLESPACE RDC_DSOS_04;
ALTER TABLE ATTRIB_MDAY_YN_VAL_DSOS MOVE SUBPARTITION AM_YN_VAL_DSOS_2016P09 TABLESPACE RDC_DSOS_01;
ALTER TABLE ATTRIB_MDAY_YN_VAL_DSOS MOVE SUBPARTITION AM_YN_VAL_DSOS_2016P10 TABLESPACE RDC_DSOS_02;
ALTER TABLE ATTRIB_MDAY_YN_VAL_DSOS MOVE SUBPARTITION AM_YN_VAL_DSOS_2016P11 TABLESPACE RDC_DSOS_03;
ALTER TABLE ATTRIB_MDAY_YN_VAL_DSOS MOVE SUBPARTITION AM_YN_VAL_DSOS_2016P12 TABLESPACE RDC_DSOS_04;

begin
  for csr in
  (
  select partition_name,
  SUBPARTITION_NAME,
  'ALTER INDEX '|| index_name||' RENAME SUBPARTITION '|| SUBPARTITION_NAME||' TO ' ||partition_name||'P'||lpad(rownum,2,'0') cmd
  from user_ind_subpartitions
  where index_name = 'IDX_ATTRIB_MYN_DSOS_ATDEF'
  and partition_name like '%2016'
  order by index_name, subpartition_position
  )
  loop
    execute immediate csr.cmd;
  end loop;
end;
/

begin
  for csr in
  (
  select partition_name,
  SUBPARTITION_NAME,
  'ALTER INDEX '|| index_name||' RENAME SUBPARTITION '|| SUBPARTITION_NAME||' TO ' ||partition_name||'P'||lpad(rownum,2,'0') cmd
  from user_ind_subpartitions
  where index_name = 'PK_ATTRIB_MDAY_YN_VAL_DSOS'
  and partition_name like '%2016'
  order by index_name, subpartition_position
  )
  loop
    execute immediate csr.cmd;
  end loop;
end;
/

ALTER INDEX PK_ATTRIB_MDAY_YN_VAL_DSOS MODIFY DEFAULT ATTRIBUTES FOR PARTITION AM_YN_VAL_DSOS_2016 TABLESPACE RDC_DSOS_IDX_01 STORAGE (INITIAL 20971520 NEXT 41943040 FREELISTS 4 FREELIST GROUPS 2);
ALTER INDEX IDX_ATTRIB_MYN_DSOS_ATDEF MODIFY DEFAULT ATTRIBUTES FOR PARTITION AM_YN_VAL_DSOS_2016 TABLESPACE RDC_DSOS_IDX_01 STORAGE (INITIAL 20971520 NEXT 41943040 FREELISTS 4 FREELIST GROUPS 2);

---
ALTER TABLE ATTRIB_MDAY_YN_VAL_DSOS SPLIT PARTITION AM_YN_VAL_DSOS_2016 AT (2016) INTO
(PARTITION AM_YN_VAL_DSOS_2015 TABLESPACE RDC_DSOS_01, PARTITION AM_YN_VAL_DSOS_2016 TABLESPACE RDC_DSOS_01);

begin
  for csr in
  (
  select partition_name,
  'ALTER TABLE ATTRIB_MDAY_YN_VAL_DSOS RENAME SUBPARTITION '|| SUBPARTITION_NAME||' TO ' ||partition_name||'P'||lpad(rownum,2,'0') cmd
  from user_tab_subpartitions
  where table_name = 'ATTRIB_MDAY_YN_VAL_DSOS'
  and partition_name like '%2015'
  order by subpartition_position
  )
  loop
    execute immediate csr.cmd;
  end loop;
end;
/

ALTER TABLE ATTRIB_MDAY_YN_VAL_DSOS MOVE SUBPARTITION AM_YN_VAL_DSOS_2015P01 TABLESPACE RDC_DSOS_01;
ALTER TABLE ATTRIB_MDAY_YN_VAL_DSOS MOVE SUBPARTITION AM_YN_VAL_DSOS_2015P02 TABLESPACE RDC_DSOS_02;
ALTER TABLE ATTRIB_MDAY_YN_VAL_DSOS MOVE SUBPARTITION AM_YN_VAL_DSOS_2015P03 TABLESPACE RDC_DSOS_03;
ALTER TABLE ATTRIB_MDAY_YN_VAL_DSOS MOVE SUBPARTITION AM_YN_VAL_DSOS_2015P04 TABLESPACE RDC_DSOS_04;
ALTER TABLE ATTRIB_MDAY_YN_VAL_DSOS MOVE SUBPARTITION AM_YN_VAL_DSOS_2015P05 TABLESPACE RDC_DSOS_01;
ALTER TABLE ATTRIB_MDAY_YN_VAL_DSOS MOVE SUBPARTITION AM_YN_VAL_DSOS_2015P06 TABLESPACE RDC_DSOS_02;
ALTER TABLE ATTRIB_MDAY_YN_VAL_DSOS MOVE SUBPARTITION AM_YN_VAL_DSOS_2015P07 TABLESPACE RDC_DSOS_03;
ALTER TABLE ATTRIB_MDAY_YN_VAL_DSOS MOVE SUBPARTITION AM_YN_VAL_DSOS_2015P08 TABLESPACE RDC_DSOS_04;
ALTER TABLE ATTRIB_MDAY_YN_VAL_DSOS MOVE SUBPARTITION AM_YN_VAL_DSOS_2015P09 TABLESPACE RDC_DSOS_01;
ALTER TABLE ATTRIB_MDAY_YN_VAL_DSOS MOVE SUBPARTITION AM_YN_VAL_DSOS_2015P10 TABLESPACE RDC_DSOS_02;
ALTER TABLE ATTRIB_MDAY_YN_VAL_DSOS MOVE SUBPARTITION AM_YN_VAL_DSOS_2015P11 TABLESPACE RDC_DSOS_03;
ALTER TABLE ATTRIB_MDAY_YN_VAL_DSOS MOVE SUBPARTITION AM_YN_VAL_DSOS_2015P12 TABLESPACE RDC_DSOS_04;

begin
  for csr in
  (
  select partition_name,
  SUBPARTITION_NAME,
  'ALTER INDEX '|| index_name||' RENAME SUBPARTITION '|| SUBPARTITION_NAME||' TO ' ||partition_name||'P'||lpad(rownum,2,'0') cmd
  from user_ind_subpartitions
  where index_name = 'IDX_ATTRIB_MYN_DSOS_ATDEF'
  and partition_name like '%2015'
  order by index_name, subpartition_position
  )
  loop
    execute immediate csr.cmd;
  end loop;
end;
/

begin
  for csr in
  (
  select partition_name,
  SUBPARTITION_NAME,
  'ALTER INDEX '|| index_name||' RENAME SUBPARTITION '|| SUBPARTITION_NAME||' TO ' ||partition_name||'P'||lpad(rownum,2,'0') cmd
  from user_ind_subpartitions
  where index_name = 'PK_ATTRIB_MDAY_YN_VAL_DSOS'
  and partition_name like '%2015'
  order by index_name, subpartition_position
  )
  loop
    execute immediate csr.cmd;
  end loop;
end;
/

ALTER INDEX PK_ATTRIB_MDAY_YN_VAL_DSOS REBUILD SUBPARTITION AM_YN_VAL_DSOS_2015P01 TABLESPACE RDC_DSOS_IDX_01;
ALTER INDEX PK_ATTRIB_MDAY_YN_VAL_DSOS REBUILD SUBPARTITION AM_YN_VAL_DSOS_2015P02 TABLESPACE RDC_DSOS_IDX_02;
ALTER INDEX PK_ATTRIB_MDAY_YN_VAL_DSOS REBUILD SUBPARTITION AM_YN_VAL_DSOS_2015P03 TABLESPACE RDC_DSOS_IDX_03;
ALTER INDEX PK_ATTRIB_MDAY_YN_VAL_DSOS REBUILD SUBPARTITION AM_YN_VAL_DSOS_2015P04 TABLESPACE RDC_DSOS_IDX_04;
ALTER INDEX PK_ATTRIB_MDAY_YN_VAL_DSOS REBUILD SUBPARTITION AM_YN_VAL_DSOS_2015P05 TABLESPACE RDC_DSOS_IDX_01;
ALTER INDEX PK_ATTRIB_MDAY_YN_VAL_DSOS REBUILD SUBPARTITION AM_YN_VAL_DSOS_2015P06 TABLESPACE RDC_DSOS_IDX_02;
ALTER INDEX PK_ATTRIB_MDAY_YN_VAL_DSOS REBUILD SUBPARTITION AM_YN_VAL_DSOS_2015P07 TABLESPACE RDC_DSOS_IDX_03;
ALTER INDEX PK_ATTRIB_MDAY_YN_VAL_DSOS REBUILD SUBPARTITION AM_YN_VAL_DSOS_2015P08 TABLESPACE RDC_DSOS_IDX_04;
ALTER INDEX PK_ATTRIB_MDAY_YN_VAL_DSOS REBUILD SUBPARTITION AM_YN_VAL_DSOS_2015P09 TABLESPACE RDC_DSOS_IDX_01;
ALTER INDEX PK_ATTRIB_MDAY_YN_VAL_DSOS REBUILD SUBPARTITION AM_YN_VAL_DSOS_2015P10 TABLESPACE RDC_DSOS_IDX_02;
ALTER INDEX PK_ATTRIB_MDAY_YN_VAL_DSOS REBUILD SUBPARTITION AM_YN_VAL_DSOS_2015P11 TABLESPACE RDC_DSOS_IDX_03;
ALTER INDEX PK_ATTRIB_MDAY_YN_VAL_DSOS REBUILD SUBPARTITION AM_YN_VAL_DSOS_2015P12 TABLESPACE RDC_DSOS_IDX_04;

ALTER INDEX IDX_ATTRIB_MYN_DSOS_ATDEF REBUILD SUBPARTITION AM_YN_VAL_DSOS_2015P01 TABLESPACE RDC_DSOS_IDX_01;
ALTER INDEX IDX_ATTRIB_MYN_DSOS_ATDEF REBUILD SUBPARTITION AM_YN_VAL_DSOS_2015P02 TABLESPACE RDC_DSOS_IDX_02;
ALTER INDEX IDX_ATTRIB_MYN_DSOS_ATDEF REBUILD SUBPARTITION AM_YN_VAL_DSOS_2015P03 TABLESPACE RDC_DSOS_IDX_03;
ALTER INDEX IDX_ATTRIB_MYN_DSOS_ATDEF REBUILD SUBPARTITION AM_YN_VAL_DSOS_2015P04 TABLESPACE RDC_DSOS_IDX_04;
ALTER INDEX IDX_ATTRIB_MYN_DSOS_ATDEF REBUILD SUBPARTITION AM_YN_VAL_DSOS_2015P05 TABLESPACE RDC_DSOS_IDX_01;
ALTER INDEX IDX_ATTRIB_MYN_DSOS_ATDEF REBUILD SUBPARTITION AM_YN_VAL_DSOS_2015P06 TABLESPACE RDC_DSOS_IDX_02;
ALTER INDEX IDX_ATTRIB_MYN_DSOS_ATDEF REBUILD SUBPARTITION AM_YN_VAL_DSOS_2015P07 TABLESPACE RDC_DSOS_IDX_03;
ALTER INDEX IDX_ATTRIB_MYN_DSOS_ATDEF REBUILD SUBPARTITION AM_YN_VAL_DSOS_2015P08 TABLESPACE RDC_DSOS_IDX_04;
ALTER INDEX IDX_ATTRIB_MYN_DSOS_ATDEF REBUILD SUBPARTITION AM_YN_VAL_DSOS_2015P09 TABLESPACE RDC_DSOS_IDX_01;
ALTER INDEX IDX_ATTRIB_MYN_DSOS_ATDEF REBUILD SUBPARTITION AM_YN_VAL_DSOS_2015P10 TABLESPACE RDC_DSOS_IDX_02;
ALTER INDEX IDX_ATTRIB_MYN_DSOS_ATDEF REBUILD SUBPARTITION AM_YN_VAL_DSOS_2015P11 TABLESPACE RDC_DSOS_IDX_03;
ALTER INDEX IDX_ATTRIB_MYN_DSOS_ATDEF REBUILD SUBPARTITION AM_YN_VAL_DSOS_2015P12 TABLESPACE RDC_DSOS_IDX_04;

ALTER INDEX PK_ATTRIB_MDAY_YN_VAL_DSOS MODIFY DEFAULT ATTRIBUTES FOR PARTITION AM_YN_VAL_DSOS_2015 TABLESPACE RDC_DSOS_IDX_01 STORAGE (INITIAL 20971520 NEXT 41943040 FREELISTS 4 FREELIST GROUPS 2);
ALTER INDEX IDX_ATTRIB_MYN_DSOS_ATDEF MODIFY DEFAULT ATTRIBUTES FOR PARTITION AM_YN_VAL_DSOS_2015 TABLESPACE RDC_DSOS_IDX_01 STORAGE (INITIAL 20971520 NEXT 41943040 FREELISTS 4 FREELIST GROUPS 2);

ALTER INDEX PK_ATTRIB_MDAY_YN_VAL_DSOS REBUILD SUBPARTITION AM_YN_VAL_DSOS_2016P01 TABLESPACE RDC_DSOS_IDX_01;
ALTER INDEX PK_ATTRIB_MDAY_YN_VAL_DSOS REBUILD SUBPARTITION AM_YN_VAL_DSOS_2016P02 TABLESPACE RDC_DSOS_IDX_02;
ALTER INDEX PK_ATTRIB_MDAY_YN_VAL_DSOS REBUILD SUBPARTITION AM_YN_VAL_DSOS_2016P03 TABLESPACE RDC_DSOS_IDX_03;
ALTER INDEX PK_ATTRIB_MDAY_YN_VAL_DSOS REBUILD SUBPARTITION AM_YN_VAL_DSOS_2016P04 TABLESPACE RDC_DSOS_IDX_04;
ALTER INDEX PK_ATTRIB_MDAY_YN_VAL_DSOS REBUILD SUBPARTITION AM_YN_VAL_DSOS_2016P05 TABLESPACE RDC_DSOS_IDX_01;
ALTER INDEX PK_ATTRIB_MDAY_YN_VAL_DSOS REBUILD SUBPARTITION AM_YN_VAL_DSOS_2016P06 TABLESPACE RDC_DSOS_IDX_02;
ALTER INDEX PK_ATTRIB_MDAY_YN_VAL_DSOS REBUILD SUBPARTITION AM_YN_VAL_DSOS_2016P07 TABLESPACE RDC_DSOS_IDX_03;
ALTER INDEX PK_ATTRIB_MDAY_YN_VAL_DSOS REBUILD SUBPARTITION AM_YN_VAL_DSOS_2016P08 TABLESPACE RDC_DSOS_IDX_04;
ALTER INDEX PK_ATTRIB_MDAY_YN_VAL_DSOS REBUILD SUBPARTITION AM_YN_VAL_DSOS_2016P09 TABLESPACE RDC_DSOS_IDX_01;
ALTER INDEX PK_ATTRIB_MDAY_YN_VAL_DSOS REBUILD SUBPARTITION AM_YN_VAL_DSOS_2016P10 TABLESPACE RDC_DSOS_IDX_02;
ALTER INDEX PK_ATTRIB_MDAY_YN_VAL_DSOS REBUILD SUBPARTITION AM_YN_VAL_DSOS_2016P11 TABLESPACE RDC_DSOS_IDX_03;
ALTER INDEX PK_ATTRIB_MDAY_YN_VAL_DSOS REBUILD SUBPARTITION AM_YN_VAL_DSOS_2016P12 TABLESPACE RDC_DSOS_IDX_04;

ALTER INDEX IDX_ATTRIB_MYN_DSOS_ATDEF REBUILD SUBPARTITION AM_YN_VAL_DSOS_2016P01 TABLESPACE RDC_DSOS_IDX_01;
ALTER INDEX IDX_ATTRIB_MYN_DSOS_ATDEF REBUILD SUBPARTITION AM_YN_VAL_DSOS_2016P02 TABLESPACE RDC_DSOS_IDX_02;
ALTER INDEX IDX_ATTRIB_MYN_DSOS_ATDEF REBUILD SUBPARTITION AM_YN_VAL_DSOS_2016P03 TABLESPACE RDC_DSOS_IDX_03;
ALTER INDEX IDX_ATTRIB_MYN_DSOS_ATDEF REBUILD SUBPARTITION AM_YN_VAL_DSOS_2016P04 TABLESPACE RDC_DSOS_IDX_04;
ALTER INDEX IDX_ATTRIB_MYN_DSOS_ATDEF REBUILD SUBPARTITION AM_YN_VAL_DSOS_2016P05 TABLESPACE RDC_DSOS_IDX_01;
ALTER INDEX IDX_ATTRIB_MYN_DSOS_ATDEF REBUILD SUBPARTITION AM_YN_VAL_DSOS_2016P06 TABLESPACE RDC_DSOS_IDX_02;
ALTER INDEX IDX_ATTRIB_MYN_DSOS_ATDEF REBUILD SUBPARTITION AM_YN_VAL_DSOS_2016P07 TABLESPACE RDC_DSOS_IDX_03;
ALTER INDEX IDX_ATTRIB_MYN_DSOS_ATDEF REBUILD SUBPARTITION AM_YN_VAL_DSOS_2016P08 TABLESPACE RDC_DSOS_IDX_04;
ALTER INDEX IDX_ATTRIB_MYN_DSOS_ATDEF REBUILD SUBPARTITION AM_YN_VAL_DSOS_2016P09 TABLESPACE RDC_DSOS_IDX_01;
ALTER INDEX IDX_ATTRIB_MYN_DSOS_ATDEF REBUILD SUBPARTITION AM_YN_VAL_DSOS_2016P10 TABLESPACE RDC_DSOS_IDX_02;
ALTER INDEX IDX_ATTRIB_MYN_DSOS_ATDEF REBUILD SUBPARTITION AM_YN_VAL_DSOS_2016P11 TABLESPACE RDC_DSOS_IDX_03;
ALTER INDEX IDX_ATTRIB_MYN_DSOS_ATDEF REBUILD SUBPARTITION AM_YN_VAL_DSOS_2016P12 TABLESPACE RDC_DSOS_IDX_04;

ALTER INDEX PK_ATTRIB_MDAY_YN_VAL_DSOS REBUILD SUBPARTITION AM_YN_VAL_DSOS_2017P01 TABLESPACE RDC_DSOS_IDX_01;
ALTER INDEX PK_ATTRIB_MDAY_YN_VAL_DSOS REBUILD SUBPARTITION AM_YN_VAL_DSOS_2017P02 TABLESPACE RDC_DSOS_IDX_02;
ALTER INDEX PK_ATTRIB_MDAY_YN_VAL_DSOS REBUILD SUBPARTITION AM_YN_VAL_DSOS_2017P03 TABLESPACE RDC_DSOS_IDX_03;
ALTER INDEX PK_ATTRIB_MDAY_YN_VAL_DSOS REBUILD SUBPARTITION AM_YN_VAL_DSOS_2017P04 TABLESPACE RDC_DSOS_IDX_04;
ALTER INDEX PK_ATTRIB_MDAY_YN_VAL_DSOS REBUILD SUBPARTITION AM_YN_VAL_DSOS_2017P05 TABLESPACE RDC_DSOS_IDX_01;
ALTER INDEX PK_ATTRIB_MDAY_YN_VAL_DSOS REBUILD SUBPARTITION AM_YN_VAL_DSOS_2017P06 TABLESPACE RDC_DSOS_IDX_02;
ALTER INDEX PK_ATTRIB_MDAY_YN_VAL_DSOS REBUILD SUBPARTITION AM_YN_VAL_DSOS_2017P07 TABLESPACE RDC_DSOS_IDX_03;
ALTER INDEX PK_ATTRIB_MDAY_YN_VAL_DSOS REBUILD SUBPARTITION AM_YN_VAL_DSOS_2017P08 TABLESPACE RDC_DSOS_IDX_04;
ALTER INDEX PK_ATTRIB_MDAY_YN_VAL_DSOS REBUILD SUBPARTITION AM_YN_VAL_DSOS_2017P09 TABLESPACE RDC_DSOS_IDX_01;
ALTER INDEX PK_ATTRIB_MDAY_YN_VAL_DSOS REBUILD SUBPARTITION AM_YN_VAL_DSOS_2017P10 TABLESPACE RDC_DSOS_IDX_02;
ALTER INDEX PK_ATTRIB_MDAY_YN_VAL_DSOS REBUILD SUBPARTITION AM_YN_VAL_DSOS_2017P11 TABLESPACE RDC_DSOS_IDX_03;
ALTER INDEX PK_ATTRIB_MDAY_YN_VAL_DSOS REBUILD SUBPARTITION AM_YN_VAL_DSOS_2017P12 TABLESPACE RDC_DSOS_IDX_04;

ALTER INDEX IDX_ATTRIB_MYN_DSOS_ATDEF REBUILD SUBPARTITION AM_YN_VAL_DSOS_2017P01 TABLESPACE RDC_DSOS_IDX_01;
ALTER INDEX IDX_ATTRIB_MYN_DSOS_ATDEF REBUILD SUBPARTITION AM_YN_VAL_DSOS_2017P02 TABLESPACE RDC_DSOS_IDX_02;
ALTER INDEX IDX_ATTRIB_MYN_DSOS_ATDEF REBUILD SUBPARTITION AM_YN_VAL_DSOS_2017P03 TABLESPACE RDC_DSOS_IDX_03;
ALTER INDEX IDX_ATTRIB_MYN_DSOS_ATDEF REBUILD SUBPARTITION AM_YN_VAL_DSOS_2017P04 TABLESPACE RDC_DSOS_IDX_04;
ALTER INDEX IDX_ATTRIB_MYN_DSOS_ATDEF REBUILD SUBPARTITION AM_YN_VAL_DSOS_2017P05 TABLESPACE RDC_DSOS_IDX_01;
ALTER INDEX IDX_ATTRIB_MYN_DSOS_ATDEF REBUILD SUBPARTITION AM_YN_VAL_DSOS_2017P06 TABLESPACE RDC_DSOS_IDX_02;
ALTER INDEX IDX_ATTRIB_MYN_DSOS_ATDEF REBUILD SUBPARTITION AM_YN_VAL_DSOS_2017P07 TABLESPACE RDC_DSOS_IDX_03;
ALTER INDEX IDX_ATTRIB_MYN_DSOS_ATDEF REBUILD SUBPARTITION AM_YN_VAL_DSOS_2017P08 TABLESPACE RDC_DSOS_IDX_04;
ALTER INDEX IDX_ATTRIB_MYN_DSOS_ATDEF REBUILD SUBPARTITION AM_YN_VAL_DSOS_2017P09 TABLESPACE RDC_DSOS_IDX_01;
ALTER INDEX IDX_ATTRIB_MYN_DSOS_ATDEF REBUILD SUBPARTITION AM_YN_VAL_DSOS_2017P10 TABLESPACE RDC_DSOS_IDX_02;
ALTER INDEX IDX_ATTRIB_MYN_DSOS_ATDEF REBUILD SUBPARTITION AM_YN_VAL_DSOS_2017P11 TABLESPACE RDC_DSOS_IDX_03;
ALTER INDEX IDX_ATTRIB_MYN_DSOS_ATDEF REBUILD SUBPARTITION AM_YN_VAL_DSOS_2017P12 TABLESPACE RDC_DSOS_IDX_04;

ALTER INDEX PK_ATTRIB_MDAY_YN_VAL_DSOS REBUILD SUBPARTITION AM_YN_VAL_DSOS_MAXXP01 TABLESPACE RDC_DSOS_IDX_01;
ALTER INDEX PK_ATTRIB_MDAY_YN_VAL_DSOS REBUILD SUBPARTITION AM_YN_VAL_DSOS_MAXXP02 TABLESPACE RDC_DSOS_IDX_02;
ALTER INDEX PK_ATTRIB_MDAY_YN_VAL_DSOS REBUILD SUBPARTITION AM_YN_VAL_DSOS_MAXXP03 TABLESPACE RDC_DSOS_IDX_03;
ALTER INDEX PK_ATTRIB_MDAY_YN_VAL_DSOS REBUILD SUBPARTITION AM_YN_VAL_DSOS_MAXXP04 TABLESPACE RDC_DSOS_IDX_04;
ALTER INDEX PK_ATTRIB_MDAY_YN_VAL_DSOS REBUILD SUBPARTITION AM_YN_VAL_DSOS_MAXXP05 TABLESPACE RDC_DSOS_IDX_01;
ALTER INDEX PK_ATTRIB_MDAY_YN_VAL_DSOS REBUILD SUBPARTITION AM_YN_VAL_DSOS_MAXXP06 TABLESPACE RDC_DSOS_IDX_02;
ALTER INDEX PK_ATTRIB_MDAY_YN_VAL_DSOS REBUILD SUBPARTITION AM_YN_VAL_DSOS_MAXXP07 TABLESPACE RDC_DSOS_IDX_03;
ALTER INDEX PK_ATTRIB_MDAY_YN_VAL_DSOS REBUILD SUBPARTITION AM_YN_VAL_DSOS_MAXXP08 TABLESPACE RDC_DSOS_IDX_04;
ALTER INDEX PK_ATTRIB_MDAY_YN_VAL_DSOS REBUILD SUBPARTITION AM_YN_VAL_DSOS_MAXXP09 TABLESPACE RDC_DSOS_IDX_01;
ALTER INDEX PK_ATTRIB_MDAY_YN_VAL_DSOS REBUILD SUBPARTITION AM_YN_VAL_DSOS_MAXXP10 TABLESPACE RDC_DSOS_IDX_02;
ALTER INDEX PK_ATTRIB_MDAY_YN_VAL_DSOS REBUILD SUBPARTITION AM_YN_VAL_DSOS_MAXXP11 TABLESPACE RDC_DSOS_IDX_03;
ALTER INDEX PK_ATTRIB_MDAY_YN_VAL_DSOS REBUILD SUBPARTITION AM_YN_VAL_DSOS_MAXXP12 TABLESPACE RDC_DSOS_IDX_04;

ALTER INDEX IDX_ATTRIB_MYN_DSOS_ATDEF REBUILD SUBPARTITION AM_YN_VAL_DSOS_MAXXP01 TABLESPACE RDC_DSOS_IDX_01;
ALTER INDEX IDX_ATTRIB_MYN_DSOS_ATDEF REBUILD SUBPARTITION AM_YN_VAL_DSOS_MAXXP02 TABLESPACE RDC_DSOS_IDX_02;
ALTER INDEX IDX_ATTRIB_MYN_DSOS_ATDEF REBUILD SUBPARTITION AM_YN_VAL_DSOS_MAXXP03 TABLESPACE RDC_DSOS_IDX_03;
ALTER INDEX IDX_ATTRIB_MYN_DSOS_ATDEF REBUILD SUBPARTITION AM_YN_VAL_DSOS_MAXXP04 TABLESPACE RDC_DSOS_IDX_04;
ALTER INDEX IDX_ATTRIB_MYN_DSOS_ATDEF REBUILD SUBPARTITION AM_YN_VAL_DSOS_MAXXP05 TABLESPACE RDC_DSOS_IDX_01;
ALTER INDEX IDX_ATTRIB_MYN_DSOS_ATDEF REBUILD SUBPARTITION AM_YN_VAL_DSOS_MAXXP06 TABLESPACE RDC_DSOS_IDX_02;
ALTER INDEX IDX_ATTRIB_MYN_DSOS_ATDEF REBUILD SUBPARTITION AM_YN_VAL_DSOS_MAXXP07 TABLESPACE RDC_DSOS_IDX_03;
ALTER INDEX IDX_ATTRIB_MYN_DSOS_ATDEF REBUILD SUBPARTITION AM_YN_VAL_DSOS_MAXXP08 TABLESPACE RDC_DSOS_IDX_04;
ALTER INDEX IDX_ATTRIB_MYN_DSOS_ATDEF REBUILD SUBPARTITION AM_YN_VAL_DSOS_MAXXP09 TABLESPACE RDC_DSOS_IDX_01;
ALTER INDEX IDX_ATTRIB_MYN_DSOS_ATDEF REBUILD SUBPARTITION AM_YN_VAL_DSOS_MAXXP10 TABLESPACE RDC_DSOS_IDX_02;
ALTER INDEX IDX_ATTRIB_MYN_DSOS_ATDEF REBUILD SUBPARTITION AM_YN_VAL_DSOS_MAXXP11 TABLESPACE RDC_DSOS_IDX_03;
ALTER INDEX IDX_ATTRIB_MYN_DSOS_ATDEF REBUILD SUBPARTITION AM_YN_VAL_DSOS_MAXXP12 TABLESPACE RDC_DSOS_IDX_04;