Posted By: Alexander1 Partitioned table by range with interval - 10/19/21 08:10 AM
Hi!
The script of the partitioned table by range with interval is being built incorrectly. The interval parameter is not taken into account.
This is indeed on the list of enhancement requests.
This has been an issue for at least 3 releases and is still not fixed. it's a significant issue because viewing a table and then switching to the SQL generates the cleanest DDL (better than DBMS_METADATA). However, the partitioning clause has to be written by hand. This also affects comparisons between schemas/databases because you get tons of false positives when the number of partitions is different, even when the DDL is the same.

Frankly, I would prefer this fix over any superficial updates to the icons, or the addition of a dark theme.
© Allround Automations forums