Range Partition

How Oracle Move Partition to Another Tablespace

by Ed Chen
December 10, 2021May 15, 2022

ALTER TABLE MOVE PARTITION A partitioned table is one type of table which data is divided into several segments. Segment is different from schema object,… Read More »

Partition Keys Can Make Unique Indexes Useless

by Ed Chen
November 25, 2015March 29, 2018

Normally, we build an unique index for protecting the table from inserting duplicate values of combined columns. If the constraint of the unique index is… Read More »

How to Resolve ERROR 1481 (HY000): MAXVALUE can only be used in last partition definition

by Ed Chen
September 29, 2014March 29, 2018
1 Comment

In practice, we usually provide a default partition for settling remainders row of tables when we apply range partitions.mysql> alter table orders partition by range(year(puchase_date))… Read More »

How to Use a Timestamp Column as a Partition Key

by Ed Chen
September 3, 2013May 17, 2019
2 Comments

Using a date or int column as a partition key is a lot easier than using a timestamp column in MySQL. Because the final datetime… Read More »