http://netvouz.com/MondoTofu/tag/partition?feed=rss MondoTofu's bookmarks tagged "partition" on Netvouz https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:4098126300346150794 Updating a large table with partition exchange. Oracle > Internals MondoTofu Tue, 06 Oct 2015 21:31:40 GMT http://www.oracle-developer.net/display.php?id=515 Adrian Billington teaches listagg function with examples, GROUP BY , comparison of alternates to listagg, including WM_CONCAT and CAST with COLLECT Oracle > DB 11g MondoTofu Fri, 31 May 2013 13:46:07 GMT 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://www.dba-oracle.com/t_11g_new_virtual_column.htm virtual column and partition by this derived column Oracle > DB 11g MondoTofu Thu, 09 Oct 2014 22:12:56 GMT http://etutorials.org/SQL/Mastering+Oracle+SQL/Chapter+10.+Partitioning/10.5+Specifying+Partitions/ SUBPARTITION clause to focus on a single subpartition of the table. Oracle > DB 11g MondoTofu Tue, 02 Jun 2015 20:39:30 GMT http://www.morganslibrary.org/reference/partitions.html Oracle 12c resource for managing partitions Oracle MondoTofu Mon, 13 Apr 2015 17:22:52 GMT http://dba.stackexchange.com/questions/33225/rename-interval-partitioning-system-generated-partition-names Rename interval partitioning system generated partition names Oracle > DB 11g MondoTofu Tue, 14 Apr 2015 20:15:22 GMT http://docs.oracle.com/cd/E11882_01/server.112/e25523/partition.htm#g471747 Partitioning for Performance Oracle > DB 11g MondoTofu Fri, 13 Sep 2013 17:06:37 GMT