Filtered move
I know about the "ALTER TABLE MOVE INCLUDING ROWS" but am unsure whether the same syntax will work on the table partition. I currently have no partition to test. I would like to know whether the following statement is legal:
ALTER TABLE TB1 MOVE PARTITION PART1 INCLUDING ROWS WHERE <my criteria>;
Regards