http://netvouz.com/MondoTofu/tag/attributes?feed=rss MondoTofu's bookmarks tagged "attributes" 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