Monday, March 17, 2014

merge and split inteval partitions

ALTER TABLE OWNER1.BID  MERGE PARTITIONS FOR (210329999), for (210399999) update indexes;

ALTER TABLE OWNER1.BID  SPLIT PARTITION SYS_P4618 at (191000000) INTO ( PARTITION p0, PARTITION p1) update indexes;


command to change interval value.

ALTER TABLE OWNER1.BID SET INTERVAL (1000000);