-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathATTRIB_MDAY_MONEY_VAL_DSOS_2018_alpha.SQL
More file actions
111 lines (101 loc) · 7.57 KB
/
ATTRIB_MDAY_MONEY_VAL_DSOS_2018_alpha.SQL
File metadata and controls
111 lines (101 loc) · 7.57 KB
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
ALTER TABLE ATTRIB_MDAY_MONEY_VAL_DSOS SPLIT PARTITION AMMONEY_VAL_DSOS_MAXX AT (2019) INTO
(PARTITION AMMONEY_VAL_DSOS_2018 TABLESPACE RDC_DSOS_02, PARTITION AMMONEY_VAL_DSOS_MAXX TABLESPACE RDC_DSOS_01);
begin
for csr in
(
select partition_name,
'ALTER TABLE ATTRIB_MDAY_MONEY_VAL_DSOS RENAME SUBPARTITION '|| SUBPARTITION_NAME||' TO ' ||partition_name||'P'||lpad(rownum,2,'0') cmd
from user_tab_subpartitions
where table_name = 'ATTRIB_MDAY_MONEY_VAL_DSOS'
and partition_name like '%2018'
order by 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 = 'IDX_ATTRIB_MMON_DSOS_ATDEF'
and partition_name like '%2018'
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_MONEY_VAL_DSOS'
and partition_name like '%2018'
order by index_name, subpartition_position
)
loop
execute immediate csr.cmd;
end loop;
end;
/
ALTER INDEX PK_ATTRIB_MDAY_MONEY_VAL_DSOS MODIFY DEFAULT ATTRIBUTES FOR PARTITION AMMONEY_VAL_DSOS_2018 TABLESPACE RDC_DSOS_IDX_01 STORAGE (INITIAL 20971520 NEXT 41943040 FREELISTS 4 FREELIST GROUPS 2);
ALTER INDEX PK_ATTRIB_MDAY_MONEY_VAL_DSOS MODIFY DEFAULT ATTRIBUTES FOR PARTITION AMMONEY_VAL_DSOS_MAXX TABLESPACE RDC_DSOS_IDX_01 STORAGE (INITIAL 20971520 NEXT 41943040 FREELISTS 4 FREELIST GROUPS 2);
ALTER INDEX IDX_ATTRIB_MMON_DSOS_ATDEF MODIFY DEFAULT ATTRIBUTES FOR PARTITION AMMONEY_VAL_DSOS_2018 TABLESPACE RDC_DSOS_IDX_01 STORAGE (INITIAL 20971520 NEXT 41943040 FREELISTS 4 FREELIST GROUPS 2);
ALTER INDEX IDX_ATTRIB_MMON_DSOS_ATDEF MODIFY DEFAULT ATTRIBUTES FOR PARTITION AMMONEY_VAL_DSOS_MAXX TABLESPACE RDC_DSOS_IDX_01 STORAGE (INITIAL 20971520 NEXT 41943040 FREELISTS 4 FREELIST GROUPS 2);
ALTER INDEX PK_ATTRIB_MDAY_MONEY_VAL_DSOS REBUILD SUBPARTITION AMMONEY_VAL_DSOS_2018P01 TABLESPACE RDC_DSOS_IDX_01;
ALTER INDEX PK_ATTRIB_MDAY_MONEY_VAL_DSOS REBUILD SUBPARTITION AMMONEY_VAL_DSOS_2018P02 TABLESPACE RDC_DSOS_IDX_02;
ALTER INDEX PK_ATTRIB_MDAY_MONEY_VAL_DSOS REBUILD SUBPARTITION AMMONEY_VAL_DSOS_2018P03 TABLESPACE RDC_DSOS_IDX_03;
ALTER INDEX PK_ATTRIB_MDAY_MONEY_VAL_DSOS REBUILD SUBPARTITION AMMONEY_VAL_DSOS_2018P04 TABLESPACE RDC_DSOS_IDX_04;
ALTER INDEX PK_ATTRIB_MDAY_MONEY_VAL_DSOS REBUILD SUBPARTITION AMMONEY_VAL_DSOS_2018P05 TABLESPACE RDC_DSOS_IDX_01;
ALTER INDEX PK_ATTRIB_MDAY_MONEY_VAL_DSOS REBUILD SUBPARTITION AMMONEY_VAL_DSOS_2018P06 TABLESPACE RDC_DSOS_IDX_02;
ALTER INDEX PK_ATTRIB_MDAY_MONEY_VAL_DSOS REBUILD SUBPARTITION AMMONEY_VAL_DSOS_2018P07 TABLESPACE RDC_DSOS_IDX_03;
ALTER INDEX PK_ATTRIB_MDAY_MONEY_VAL_DSOS REBUILD SUBPARTITION AMMONEY_VAL_DSOS_2018P08 TABLESPACE RDC_DSOS_IDX_04;
ALTER INDEX PK_ATTRIB_MDAY_MONEY_VAL_DSOS REBUILD SUBPARTITION AMMONEY_VAL_DSOS_2018P09 TABLESPACE RDC_DSOS_IDX_01;
ALTER INDEX PK_ATTRIB_MDAY_MONEY_VAL_DSOS REBUILD SUBPARTITION AMMONEY_VAL_DSOS_2018P10 TABLESPACE RDC_DSOS_IDX_02;
ALTER INDEX PK_ATTRIB_MDAY_MONEY_VAL_DSOS REBUILD SUBPARTITION AMMONEY_VAL_DSOS_2018P11 TABLESPACE RDC_DSOS_IDX_03;
ALTER INDEX PK_ATTRIB_MDAY_MONEY_VAL_DSOS REBUILD SUBPARTITION AMMONEY_VAL_DSOS_2018P12 TABLESPACE RDC_DSOS_IDX_04;
ALTER INDEX IDX_ATTRIB_MMON_DSOS_ATDEF REBUILD SUBPARTITION AMMONEY_VAL_DSOS_2018P01 TABLESPACE RDC_DSOS_IDX_01;
ALTER INDEX IDX_ATTRIB_MMON_DSOS_ATDEF REBUILD SUBPARTITION AMMONEY_VAL_DSOS_2018P02 TABLESPACE RDC_DSOS_IDX_02;
ALTER INDEX IDX_ATTRIB_MMON_DSOS_ATDEF REBUILD SUBPARTITION AMMONEY_VAL_DSOS_2018P03 TABLESPACE RDC_DSOS_IDX_03;
ALTER INDEX IDX_ATTRIB_MMON_DSOS_ATDEF REBUILD SUBPARTITION AMMONEY_VAL_DSOS_2018P04 TABLESPACE RDC_DSOS_IDX_04;
ALTER INDEX IDX_ATTRIB_MMON_DSOS_ATDEF REBUILD SUBPARTITION AMMONEY_VAL_DSOS_2018P05 TABLESPACE RDC_DSOS_IDX_01;
ALTER INDEX IDX_ATTRIB_MMON_DSOS_ATDEF REBUILD SUBPARTITION AMMONEY_VAL_DSOS_2018P06 TABLESPACE RDC_DSOS_IDX_02;
ALTER INDEX IDX_ATTRIB_MMON_DSOS_ATDEF REBUILD SUBPARTITION AMMONEY_VAL_DSOS_2018P07 TABLESPACE RDC_DSOS_IDX_03;
ALTER INDEX IDX_ATTRIB_MMON_DSOS_ATDEF REBUILD SUBPARTITION AMMONEY_VAL_DSOS_2018P08 TABLESPACE RDC_DSOS_IDX_04;
ALTER INDEX IDX_ATTRIB_MMON_DSOS_ATDEF REBUILD SUBPARTITION AMMONEY_VAL_DSOS_2018P09 TABLESPACE RDC_DSOS_IDX_01;
ALTER INDEX IDX_ATTRIB_MMON_DSOS_ATDEF REBUILD SUBPARTITION AMMONEY_VAL_DSOS_2018P10 TABLESPACE RDC_DSOS_IDX_02;
ALTER INDEX IDX_ATTRIB_MMON_DSOS_ATDEF REBUILD SUBPARTITION AMMONEY_VAL_DSOS_2018P11 TABLESPACE RDC_DSOS_IDX_03;
ALTER INDEX IDX_ATTRIB_MMON_DSOS_ATDEF REBUILD SUBPARTITION AMMONEY_VAL_DSOS_2018P12 TABLESPACE RDC_DSOS_IDX_04;
ALTER INDEX PK_ATTRIB_MDAY_MONEY_VAL_DSOS REBUILD SUBPARTITION AMMONEY_VAL_DSOS_MAXXP01 TABLESPACE RDC_DSOS_IDX_01;
ALTER INDEX PK_ATTRIB_MDAY_MONEY_VAL_DSOS REBUILD SUBPARTITION AMMONEY_VAL_DSOS_MAXXP02 TABLESPACE RDC_DSOS_IDX_02;
ALTER INDEX PK_ATTRIB_MDAY_MONEY_VAL_DSOS REBUILD SUBPARTITION AMMONEY_VAL_DSOS_MAXXP03 TABLESPACE RDC_DSOS_IDX_03;
ALTER INDEX PK_ATTRIB_MDAY_MONEY_VAL_DSOS REBUILD SUBPARTITION AMMONEY_VAL_DSOS_MAXXP04 TABLESPACE RDC_DSOS_IDX_04;
ALTER INDEX PK_ATTRIB_MDAY_MONEY_VAL_DSOS REBUILD SUBPARTITION AMMONEY_VAL_DSOS_MAXXP05 TABLESPACE RDC_DSOS_IDX_01;
ALTER INDEX PK_ATTRIB_MDAY_MONEY_VAL_DSOS REBUILD SUBPARTITION AMMONEY_VAL_DSOS_MAXXP06 TABLESPACE RDC_DSOS_IDX_02;
ALTER INDEX PK_ATTRIB_MDAY_MONEY_VAL_DSOS REBUILD SUBPARTITION AMMONEY_VAL_DSOS_MAXXP07 TABLESPACE RDC_DSOS_IDX_03;
ALTER INDEX PK_ATTRIB_MDAY_MONEY_VAL_DSOS REBUILD SUBPARTITION AMMONEY_VAL_DSOS_MAXXP08 TABLESPACE RDC_DSOS_IDX_04;
ALTER INDEX PK_ATTRIB_MDAY_MONEY_VAL_DSOS REBUILD SUBPARTITION AMMONEY_VAL_DSOS_MAXXP09 TABLESPACE RDC_DSOS_IDX_01;
ALTER INDEX PK_ATTRIB_MDAY_MONEY_VAL_DSOS REBUILD SUBPARTITION AMMONEY_VAL_DSOS_MAXXP10 TABLESPACE RDC_DSOS_IDX_02;
ALTER INDEX PK_ATTRIB_MDAY_MONEY_VAL_DSOS REBUILD SUBPARTITION AMMONEY_VAL_DSOS_MAXXP11 TABLESPACE RDC_DSOS_IDX_03;
ALTER INDEX PK_ATTRIB_MDAY_MONEY_VAL_DSOS REBUILD SUBPARTITION AMMONEY_VAL_DSOS_MAXXP12 TABLESPACE RDC_DSOS_IDX_04;
ALTER INDEX IDX_ATTRIB_MMON_DSOS_ATDEF REBUILD SUBPARTITION AMMONEY_VAL_DSOS_MAXXP01 TABLESPACE RDC_DSOS_IDX_01;
ALTER INDEX IDX_ATTRIB_MMON_DSOS_ATDEF REBUILD SUBPARTITION AMMONEY_VAL_DSOS_MAXXP02 TABLESPACE RDC_DSOS_IDX_02;
ALTER INDEX IDX_ATTRIB_MMON_DSOS_ATDEF REBUILD SUBPARTITION AMMONEY_VAL_DSOS_MAXXP03 TABLESPACE RDC_DSOS_IDX_03;
ALTER INDEX IDX_ATTRIB_MMON_DSOS_ATDEF REBUILD SUBPARTITION AMMONEY_VAL_DSOS_MAXXP04 TABLESPACE RDC_DSOS_IDX_04;
ALTER INDEX IDX_ATTRIB_MMON_DSOS_ATDEF REBUILD SUBPARTITION AMMONEY_VAL_DSOS_MAXXP05 TABLESPACE RDC_DSOS_IDX_01;
ALTER INDEX IDX_ATTRIB_MMON_DSOS_ATDEF REBUILD SUBPARTITION AMMONEY_VAL_DSOS_MAXXP06 TABLESPACE RDC_DSOS_IDX_02;
ALTER INDEX IDX_ATTRIB_MMON_DSOS_ATDEF REBUILD SUBPARTITION AMMONEY_VAL_DSOS_MAXXP07 TABLESPACE RDC_DSOS_IDX_03;
ALTER INDEX IDX_ATTRIB_MMON_DSOS_ATDEF REBUILD SUBPARTITION AMMONEY_VAL_DSOS_MAXXP08 TABLESPACE RDC_DSOS_IDX_04;
ALTER INDEX IDX_ATTRIB_MMON_DSOS_ATDEF REBUILD SUBPARTITION AMMONEY_VAL_DSOS_MAXXP09 TABLESPACE RDC_DSOS_IDX_01;
ALTER INDEX IDX_ATTRIB_MMON_DSOS_ATDEF REBUILD SUBPARTITION AMMONEY_VAL_DSOS_MAXXP10 TABLESPACE RDC_DSOS_IDX_02;
ALTER INDEX IDX_ATTRIB_MMON_DSOS_ATDEF REBUILD SUBPARTITION AMMONEY_VAL_DSOS_MAXXP11 TABLESPACE RDC_DSOS_IDX_03;
ALTER INDEX IDX_ATTRIB_MMON_DSOS_ATDEF REBUILD SUBPARTITION AMMONEY_VAL_DSOS_MAXXP12 TABLESPACE RDC_DSOS_IDX_04;