When you specify WITHOUT VALIDATION for the exchange partition operation, this is normally a fast operation because it involves only data dictionary updates. In MySQL 5.7, it is possible to exchange a table partition or subpartition with a table using ALTER TABLE pt EXCHANGE PARTITION p WITH TABLE nt.I have a little problem with partiton exchange from subpartition. When creating a partitioned table or index, you include a partitioning clause in the CREATE TABLE statement. One exchange operation. Exchange (clear) out of target bottom-up.