Hi,
I understand that EA is not really a data modelling tool, but I use it for that purpose and find it works pretty well for basic operations like table creation and sequence generation.
I am now trying to partition my tables so that the scripts created automatically include the partition creation. Is this possible?
It should produce a script with something like:
CREATE TABLE PART_BY_RANGE
( ID INT NOT NULL,
BIRTH_MM INT NOT NULL,
BIRTH_DD INT NOT NULL,
BIRTH_YYYY INT NOT NULL)
PARTITION BY RANGE (BIRTH_YYYY, BIRTH_MM, BIRTH_DD)
(PARTITION PART_01 VALUES LESS THAN (2002, 02 ,01),
PARTITION PART_02 VALUES LESS THAN (2002, 03 ,01), PARTITION PART_03 VALUES LESS THAN (2002, 04 ,01), PARTITION PART_04 VALUES LESS THAN (2002, 05 ,01)
);
Thanks
