Hi all, I think this just not possible without DBMS_REDEFINITION. But correct me if I am wrong. The task is to move a partition of a partitioned IOT table. DB version is 9.2.0.5. According to syntax in Docs I cannot find the match. Tries to test and ALTER TABLE MOVE ONLINE PARTITION ... doesn't work. If you have any specific pointers to docs/Metalink - please let me know. TIA, Alex -- //www.freelists.org/webpage/oracle-l