When you specify WITHOUT VALIDATION for the exchange partition operation, this is normally a fast operation because it involves only data dictionary updates. I can swap out a specific 'known' subpartition.I know you can use the 'for' logic with Oracle 11g but can't get the syntax to work. You CAN exchange a subpartition into another table using a "temporary" (staging) table as an intermediary. This KM supports three partitioning strategies: range, hash, and list. First we create a sample schema as our starting point. -- Create and populate a small lookup table. Every partition has four subpartitions as described in the subpartition template. Each subpartition has a tablespace specified.