Print Thread
Table view sql still not showing interval partitioning clause
#48736 03/10/14 09:18 AM
Joined: Mar 2014
Posts: 3
S
Member
OP Offline
Member
S
Joined: Mar 2014
Posts: 3
Hi,

Since version 8 onwards up until version 10.05 of PL/SQL Developer when viewing the sql for table that is interval partitioned, the interval partitioning clause is missing.

What is the reason for this still now being fixed?
I saw an old thread in 2012 where this issue was raised.

Thanks

Re: Table view sql still not showing interval partitioning clause
stephan vos #48739 03/10/14 09:59 AM
Joined: Aug 1999
Posts: 22,217
Member
Offline
Member
Joined: Aug 1999
Posts: 22,217
Support for interval partitioned tables will be added in the next release. At the moment it is only supported in functions that directly extract the DDL (e.g. export, drag & drop DDL).


Marco Kalter
Allround Automations
Re: Table view sql still not showing interval partitioning clause
Marco Kalter #48771 03/14/14 05:10 AM
Joined: Mar 2014
Posts: 3
S
Member
OP Offline
Member
S
Joined: Mar 2014
Posts: 3
Thanks Marco.
Can you indicate is this will be a patch release (10.x.x) or a major release 11.x?

Re: Table view sql still not showing interval partitioning clause
stephan vos #48775 03/14/14 10:29 AM
Joined: Aug 1999
Posts: 22,217
Member
Offline
Member
Joined: Aug 1999
Posts: 22,217
This will be the 11.0 release.


Marco Kalter
Allround Automations
Re: Table view sql still not showing interval partitioning clause
Marco Kalter #51032 03/18/15 08:43 AM
Joined: Feb 2015
Posts: 24
B
bro Offline
Member
Offline
Member
B
Joined: Feb 2015
Posts: 24
Hi,
I still can't see interval clause in 11.0. Has support for it been added to 11.0 release?

Re: Table view sql still not showing interval partitioning clause
bro #51035 03/18/15 10:17 AM
Joined: Aug 1999
Posts: 22,217
Member
Offline
Member
Joined: Aug 1999
Posts: 22,217
No, unfortunately this has not yet been added.


Marco Kalter
Allround Automations
Re: Table view sql still not showing interval partitioning clause
Marco Kalter #56291 04/06/17 09:52 AM
Joined: Apr 2017
Posts: 5
Germany
D
Member
Offline
Member
D
Joined: Apr 2017
Posts: 5
Germany
Hi, what about now?

I was considering to buy a new Service Contract to be able to update to version 12, but I still couldn't find any GUI support for interval partitioning in V 12.0.2 ...




Re: Table view sql still not showing interval partitioning clause
DieterBu #56406 04/27/17 02:28 PM
Joined: Apr 2017
Posts: 5
Germany
D
Member
Offline
Member
D
Joined: Apr 2017
Posts: 5
Germany
ping

Re: Table view sql still not showing interval partitioning clause
DieterBu #56516 05/31/17 03:07 PM
Joined: Apr 2017
Posts: 5
Germany
D
Member
Offline
Member
D
Joined: Apr 2017
Posts: 5
Germany
pong


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.030s Queries: 15 (0.008s) Memory: 2.5328 MB (Peak: 3.0407 MB) Data Comp: Off Server Time: 2024-05-13 22:55:06 UTC
Valid HTML 5 and Valid CSS