-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathIDENTIFIER_2018_alpha.SQL
More file actions
31 lines (20 loc) · 2.15 KB
/
IDENTIFIER_2018_alpha.SQL
File metadata and controls
31 lines (20 loc) · 2.15 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
ALTER TABLE IDENTIFIER SPLIT PARTITION IDENTIFIER_2200_01 AT (2018, maxvalue) INTO (PARTITION IDENTIFIER_2018_04 TABLESPACE IDFIER_2002, PARTITION IDENTIFIER_2200_01 TABLESPACE IDFIER_2200);
ALTER TABLE IDENTIFIER SPLIT PARTITION IDENTIFIER_2018_04 AT (2018, 600) INTO (PARTITION IDENTIFIER_2018_03 TABLESPACE IDFIER_2002, PARTITION IDENTIFIER_2018_04 TABLESPACE IDFIER_2002);
ALTER TABLE IDENTIFIER SPLIT PARTITION IDENTIFIER_2018_03 AT (2018, 400) INTO (PARTITION IDENTIFIER_2018_02 TABLESPACE IDFIER_2002, PARTITION IDENTIFIER_2018_03 TABLESPACE IDFIER_2002);
ALTER TABLE IDENTIFIER SPLIT PARTITION IDENTIFIER_2018_02 AT (2018, 200) INTO (PARTITION IDENTIFIER_2018_01 TABLESPACE IDFIER_2002, PARTITION IDENTIFIER_2018_02 TABLESPACE IDFIER_2002);
ALTER INDEX IDX_IDENTIFIER_ATDEF REBUILD PARTITION IDENTIFIER_2018_01 TABLESPACE IDFIER_IDX_2002;
ALTER INDEX IDX_IDENTIFIER_ATDEF REBUILD PARTITION IDENTIFIER_2018_02 TABLESPACE IDFIER_IDX_2002;
ALTER INDEX IDX_IDENTIFIER_ATDEF REBUILD PARTITION IDENTIFIER_2018_03 TABLESPACE IDFIER_IDX_2002;
ALTER INDEX IDX_IDENTIFIER_ATDEF REBUILD PARTITION IDENTIFIER_2018_04 TABLESPACE IDFIER_IDX_2002;
ALTER INDEX IDX_IDENTIFIER_ATDEF REBUILD PARTITION IDENTIFIER_2200_01 TABLESPACE IDFIER_IDX_2200;
ALTER INDEX IDX_IDENTIFIER_NM_DT REBUILD PARTITION IDENTIFIER_2018_01 TABLESPACE IDFIER_IDX_2002;
ALTER INDEX IDX_IDENTIFIER_NM_DT REBUILD PARTITION IDENTIFIER_2018_02 TABLESPACE IDFIER_IDX_2002;
ALTER INDEX IDX_IDENTIFIER_NM_DT REBUILD PARTITION IDENTIFIER_2018_03 TABLESPACE IDFIER_IDX_2002;
ALTER INDEX IDX_IDENTIFIER_NM_DT REBUILD PARTITION IDENTIFIER_2018_04 TABLESPACE IDFIER_IDX_2002;
ALTER INDEX IDX_IDENTIFIER_NM_DT REBUILD PARTITION IDENTIFIER_2200_01 TABLESPACE IDFIER_IDX_2200;
ALTER INDEX PK_IDENTIFIER REBUILD PARTITION IDENTIFIER_2018_01 TABLESPACE IDFIER_IDX_2002;
ALTER INDEX PK_IDENTIFIER REBUILD PARTITION IDENTIFIER_2018_02 TABLESPACE IDFIER_IDX_2002;
ALTER INDEX PK_IDENTIFIER REBUILD PARTITION IDENTIFIER_2018_03 TABLESPACE IDFIER_IDX_2002;
ALTER INDEX PK_IDENTIFIER REBUILD PARTITION IDENTIFIER_2018_04 TABLESPACE IDFIER_IDX_2002;
--
ALTER INDEX PK_IDENTIFIER REBUILD PARTITION IDENTIFIER_2200_01 TABLESPACE IDFIER_IDX_2200;