Database Reference
In-Depth Information
Figure 18.16
CREATE TABLE
Syntax for Range-
Hash Partitions.
, SUBPARTITION S2001EverywhereElse VALUES (5,6,7,8,9,10))
, PARTITION S2002 VALUES LESS THAN (TO_DATE('2003-01-
01','YYYY-MM-DD'))
(SUBPARTITION S2002EuropeAndAmerica VALUES (1,2,3,4)
, SUBPARTITION S2002EverywhereElse VALUES (5,6,7,8,9,10))
, PARTITION S2003 VALUES LESS THAN(MAXVALUE)
(SUBPARTITION S2003EuropeAndAmerica VALUES (1,2,3,4)
, SUBPARTITION S2003EverywhereElse VALUES (5,6,7,8,9,10)))
AS SELECT * FROM SALES;
That more or less covers everything about creating tables using the
CREATE TABLE command. Now let's look at changing tables using the
ALTER TABLE command.
Figure 18.17
CREATE TABLE
Syntax for Range-
List Partitions.
Search WWH ::




Custom Search