Toad World® Forums

Partitioning of entities in Oracle Databases


#1

. 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.


#2

Hello Mark,

Please open the Entity Properties form | Table Properties tab. Here, you have to enter it manually.
Example:
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.

Regards,

Vladka + TDM Team

Message was edited by: vladka