Partitioning Tables  «Prev  Next»

Create a Partitioned Object Table

During the simulation, you created a partitioned object table. The code you created should look something like this:
CREATE TYPE GAME_TYPE  AS OBJECT
(GAME_ID NUMBER,
 GAME_NAME VARCHAR2(50),
 CATEGORY VARCHAR2(50),
 DIFFICULTY VARCHAR2(10))
/
CREATE TABLE GAMES OF GAME_TYPE
TABLESPACE USERS PCTFREE 20
PARTITION BY RANGE (GAME_NAME)
(PARTITION NAME_A_K VALUES LESS THAN ('J'),
 PARTITION NAME_J_R VALUES LESS THAN ('S'),
 PARTITION NAME_S_Z VALUES LESS THAN (MAXVALUE))
/