Partitioning Tables  «Prev 

Partitioned Object Tables in Oracle

1) An object table is based on an object type.
1) An object table is based on an object type.

2) This shows the beginning of the CREATE TABLE command, where we specify which object type is the basis for the object table.
2) This shows the beginning of the CREATE TABLE command, where we specify which object type is the basis for the object table.

3) Like the relational table, you specify storage requirements before you specify partitioning details.
3) Like the relational table, you specify storage requirements before you specify partitioning details.

4) We define the partitions. The last line in the command you see in this example specifies that you use range partitioning and the partitioning is based on the COMMON_NAME attribute.
4) We define the partitions. The last line in the command you see in this example specifies that you use range partitioning and the partitioning is based on the COMMON_NAME attribute.

5) Here you see the final three lines of the command, which describe the cutoff values for each partition.
5) Here you see the final three lines of the command, which describe the cutoff values for each partition.