Database Reference
In-Depth Information
Figure 18.13
CREATE TABLE
Syntax for Range
Partitions.
CREATE TABLE SALESLIST PARTITION BY LIST (CONTINENT_ID)(
PARTITION EuropeAndAmerica VALUES (1,2,3,4)
,PARTITION EverywhereElse VALUES (5,6,7,8,9,10))
AS SELECT * FROM SALES;
Figure 18.14 displays the CREATE TABLE list partition index.
Figure 18.14
CREATE TABLE
Syntax for List
Partitions.
18.3.6.2.3
CREATE TABLE Hash Partition Syntax
Once again, another simple example except this time using a hash partition
created as a subquery from the SALES table. (See Figure 18.15 for a dia-
gram of the syntax.)
CREATE TABLE SALESHASH
PARTITION BY HASH (SALES_ID) PARTITIONS 10
