CUST_INS_DT_IX using more meaningful
names:
SQL> alter index oe.cust_ins_dt_ix
2 rename partition sys_P1130 to cust_ins_dt_ix_P1;
Index altered.
SQL> alter index oe.cust_ins_dt_ix
2 rename partition sys_P1131 to cust_ins_dt_ix_P2;
Index altered.
SQL> alter index oe.cust_ins_dt_ix
2 rename partition sys_P1132 to cust_ins_dt_ix_P3;
Index altered.
Managing Partitions with EM Database Control
Creating and managing table and index partitions using EM Database Control saves you time and
also spares you the potential for errors. In the web pages displayed in the following figures, I??™ll show
you the steps required to create a partitioned table to support a new order-entry and quotation
system. In Figure 16-4, on the Create Table page, you specify the table name, the schema where
the table will reside, and the tablespace. You also specify the column names and their attributes.
FIGURE 16-4 EM Database Control Create Table page
Chapter 16: Managing Large Databases 583
So far, we??™re only creating a standard heap-based table with no partitioning. However, when
you click the Partitions tab, you can specify the partitioning method as shown in Figure 16-5.
For the ORDER_QUOTE table, you will choose range partitioning because you will use the
ORD_DATE column to put each row into a specific partition. In Figure 16-6, on the Create Range
Partitions: Partitioning Columns page, you specify which columns to use for partitioning using the
range method.
Pages:
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863