2009. 5. 26. 16:10
Job/정리
* Split Partition
ALTER TABLE FW_DP_LDS_DEFAULT
SPLIT PARTITION P_20090109 AT ('20090106000000')
INTO (PARTITION P_20090105 TABLESPACE OASISDB_PILOT,
PARTITION P_20090109 TABLESPACE OASISDB_PILOT);
* Add Partition
ALTER TABLE FW_1DAY_LANE_DEFAULT
ADD PARTITION P_20090109
VALUES LESS THAN ('20090110')
TABLESPACE OASISDB_PILOT;