http://netvouz.com/MondoTofu/tag/alter?feed=rss MondoTofu's bookmarks tagged "alter" on Netvouz http://amit7oracledba.blogspot.com/2013/03/move-partitioned-tables-to-different.html Changing the default tablespace of Partition table. Now new partitions will be created in the new default tablespace, but old partitions will remain in the old default tablespace :- SQL> alter table partition modify default attributes tablespace users; Table altered. Oracle > DB 11g MondoTofu Thu, 26 Jan 2017 17:20:02 GMT http://oracle-base.com/articles/11g/temporary-tablespace-enhancements-11gr1.php Temporary Tablespace Enhancements in Oracle Database 11g Release 1 Oracle > DB 11g MondoTofu Thu, 07 May 2015 17:42:01 GMT https://docs.oracle.com/cd/B28359_01/server.111/b28310/tspaces008.htm#ADMIN01104 Oracle > DB 11g MondoTofu Thu, 13 Nov 2014 23:28:39 GMT