. I am looking for an option under entity that will allows for defining the partition type and partition key and the boundary definitions for each partition.
Please open the Entity Properties form | Table Properties tab. Here, you have to enter it manually.
PARTITION BY RANGE(f1, f2)
PARTITION p1 VALUES LESS THAN (101,102) PCTFREE 22,
PARTITION p2 VALUES LESS THAN (201,202) TABLESPACE tablespace1,
PARTITION p5 VALUES LESS THAN (MAXVALUE,MAXVALUE)
If you have more questions, please write us back. Thanks.
Vladka + TDM Team
Message was edited by: vladka