728x90
ALTER TABLE TABLE_NAME SPLIT PARTITION PARTITION_NAME AS ('') INTO (PARTITION 추가할 파티션 이름, PARTITION 현재 MIN PARTITION NAME);
EX)
| 현재 MIN PARTITION NAME : MIN1, 범위: 20000201 추가할 MIN PARTITION NAME : MIN2, 범위 : 20000101 ALTER TABLE TABLE_NAME SPLIT PARTITION MIN1 AS (' 20000101 ') INTO (PARTITION MIN2 , PARTITION MIN1); |
728x90
'ORACLE' 카테고리의 다른 글
| ORA-02266: unique/primary keys in table referenced by enabled foreign keys (1) | 2024.05.27 |
|---|---|
| DEFAULT 통계정보 수집 기능 확인 및 OFF (0) | 2024.05.27 |
| ORA-14260 incorrect physical attribute specified for this partition (0) | 2024.03.04 |
| AQ table MOVE TABLESPACE (1) | 2024.02.21 |
| ORA-31693 ORA-06502 (0) | 2024.01.25 |