oracle, mysql 파티셔닝

ALTER TABLE LG_CV ADD PARTITION PT_0708 VALUES less than ('0709') TABLESPACE  ADWS_00_LG;

------mysql

ALTER TABLE EVENT_USER ADD PARTITION (PARTITION p20 VALUES LESS THAN (1021)); <추가
ALTER TABLE EVENT_USER ADD PARTITION (PARTITION p30 VALUES LESS THAN MAXVALUE); <마지막
ALTER TABLE EVENT_USER DROP PARTITION p20;< 삭제

새로 생성
 CREATE TABLE tr (id INT, name VARCHAR(50), purchased DATE)
    ->     PARTITION BY RANGE( YEAR(purchased) ) (
    ->         PARTITION p0 VALUES LESS THAN (1990),
    ->         PARTITION p1 VALUES LESS THAN (1995),
    ->         PARTITION p2 VALUES LESS THAN (2000),
    ->         PARTITION p3 VALUES LESS THAN (2005)