Oracle-Developer.com Forums

[vj.jain]

System partitioning allows application level control for partitioning a table or index. This partitioning option offers the same benefits as other methods of partitioning but the partitions are completely controlled by the application and do not have partition keys or boundaries. This option should be used carefully since all references to a system partitioned table should include extended partition syntax to specify a partition. For inserts into a system partitioned table, the partition must be specified to avoid receiving an error. For all other operations, omitting the partition will cause all partitions to be scanned.


These and more Oracle 11g features can be found at http://www.oracle-developer.com or in the Oracle 11g New Features guide being released in March 2008 at http://www.oracle-developer.com/oracle_11g_new_features.html