Print Thread
Partitioned table by range with interval
#62720 10/19/21 08:10 AM
Joined: Oct 2021
Posts: 1
Russia
A
Member
OP Offline
Member
A
Joined: Oct 2021
Posts: 1
Russia
Hi!
The script of the partitioned table by range with interval is being built incorrectly. The interval parameter is not taken into account.

Re: Partitioned table by range with interval
Alexander1 #62723 10/19/21 09:12 AM
Joined: Aug 1999
Posts: 22,201
Member
Offline
Member
Joined: Aug 1999
Posts: 22,201
This is indeed on the list of enhancement requests.


Marco Kalter
Allround Automations
Re: Partitioned table by range with interval
Alexander1 #63928 05/13/22 04:34 AM
Joined: Aug 2003
Posts: 45
Pasadena, CA
Member
Offline
Member
Joined: Aug 2003
Posts: 45
Pasadena, CA
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.


Thanks,
Ara

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.027s Queries: 15 (0.008s) Memory: 2.5002 MB (Peak: 3.0378 MB) Data Comp: Off Server Time: 2024-04-24 03:14:53 UTC
Valid HTML 5 and Valid CSS