Here is the SQL command:
CREATE TABLE "OE"."ORDER_QUOTE"
("ORD_QUOTE_NUM" NUMBER(12),
"ORD_DATE" DATE,
"CUST_NUM" NUMBER(15),
"ORD_TYP_CD" NUMBER(1),
"ORD_SRC_CD" NUMBER(1))
TABLESPACE "USERS" PARTITION BY RANGE ("ORD_DATE")
(PARTITION "ORDER_QUOTE_P1"
VALUES LESS THAN (TO_DATE('2/1/2007','MM/DD/YYYY')),
PARTITION "ORDER_QUOTE_P2"
VALUES LESS THAN (TO_DATE('3/1/2007','MM/DD/YYYY')),
PARTITION "ORDER_QUOTE_P3"
VALUES LESS THAN (TO_DATE('4/1/2007','MM/DD/YYYY')),
PARTITION "ORDER_QUOTE_P4"
VALUES LESS THAN (TO_DATE('5/1/2007','MM/DD/YYYY')),
PARTITION "ORDER_QUOTE_P5"
VALUES LESS THAN (TO_DATE('6/1/2007','MM/DD/YYYY')),
PARTITION "ORDER_QUOTE_P6"
VALUES LESS THAN (TO_DATE('7/1/2007','MM/DD/YYYY')),
FIGURE 16-10 EM Database Control Create Table summary
Chapter 16: Managing Large Databases 587
PARTITION "ORDER_QUOTE_P7"
VALUES LESS THAN (TO_DATE('8/1/2007','MM/DD/YYYY')),
PARTITION "ORDER_QUOTE_P8"
VALUES LESS THAN (TO_DATE('9/1/2007','MM/DD/YYYY')),
PARTITION "ORDER_QUOTE_P9"
VALUES LESS THAN (TO_DATE('10/1/2007','MM/DD/YYYY')),
PARTITION "ORDER_QUOTE_P10"
VALUES LESS THAN (TO_DATE('11/1/2007','MM/DD/YYYY')),
PARTITION "ORDER_QUOTE_P11"
VALUES LESS THAN (TO_DATE('12/1/2007','MM/DD/YYYY')),
PARTITION "ORDER_QUOTE_P12" VALUES LESS THAN (MAXVALUE));
Clicking Create runs the SQL command and confirms that the partitioned table has been
created, as you can see in Figure 16-11.
Editing the characteristics of a partitioned table is just as easy as creating the partitioned table
in the first place.
Pages:
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865