Range Partitioning
Range partitioning organizes rows in the various assigned tablespaces based on a column(s). As illustrated in Figure 15.1, a partitioned table is a logical table physically stored across many tablespaces.
Figure 15.1. ST_SALES range partitioned table.
NOTE
The ST_SALES partitioned table is not implemented with the other Sales Tracking objects because of the lack of physical disk drives on the author's NT platform and the lack of example data. Partitioning is useful for tables with hundreds of thousands of rows, or even millions of rows.
Listing 15.1 illustrates the CREATE TABLE syntax that creates the ST_SALES table shown in ...
Get Oracle9i™ Development by Example now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
