In this case, you??™re only using one column, ORD_DATE.
After clicking Next, you proceed to the Partitioning Specification page, as presented in Figure
16-7. Initially, you want to create 12 partitions, one partition for each month of 2007. As a result,
you specify 12 for the number of partitions, 1/1/2007 as the starting date, and one month for each
partition.
In Figure 16-8, you specify the tablespaces used to hold the partitions. In this case, you accept
the default: the tablespace originally specified for the table before partitioning was specified, which
in this case is the default tablespace for the database. Another option on this page is to spread out
the partitions among several tablespaces.
After clicking Next, you see the Partition Definitions page in Figure 16-9, where the partition
names, high values for each range, and tablespace are presented. Any changes to partition names
or locations can be made on this page??”for example, changing the name of each partition to
include the high value for the partition key.
Clicking Finish brings you back to the Create Table page, as you can see in Figure 16-10. You
have one more opportunity to change the characteristics of the partitioned table.
FIGURE 16-5 EM Database Control Partitioning Method page
584 Oracle Database 11g DBA Handbook
FIGURE 16-6 EM Database Control Partitioning Columns page
FIGURE 16-7 EM Database Control Partitioning Specification page
Chapter 16: Managing Large Databases 585
FIGURE 16-8 EM Database Control Partition Tablespaces page
FIGURE 16-9 EM Database Control Partition Definitions page
586 Oracle Database 11g DBA Handbook
This page also has a Show SQL button so that you can see the SQL command that will be run
to create the partitioned table.
Pages:
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864