Subpartitions tab is not shown

[IvanZ]

Hi,

For tables with LIST-LIST subpartitioning schema PLD doesn't show Subpatitions tab (in RMB > View window)

Example DDL:
create table list_list_parts
(
call_date date,
filial_id number
)
partition by list (filial_id)
subpartition by list (call_date)
(
partition p1 values (1)
( subpartition p20150701_1 values (to_date(' 2015-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')),
subpartition p20150101_1 values (to_date(' 2015-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')),
subpartition p20150102_1 values (to_date(' 2015-01-02 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')),
subpartition p20150103_1 values (to_date(' 2015-01-03 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) ),
partition p2 values (2)
( subpartition p20150701_2 values (to_date(' 2015-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')),
subpartition p20150101_2 values (to_date(' 2015-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')),
subpartition p20150102_2 values (to_date(' 2015-01-02 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')),
subpartition p20150103_2 values (to_date(' 2015-01-03 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) )
);

 

[Marco Kalter]

Subpartitions are currently not supported.

 

[IvanZ]

For list-range schema Subpartitions tab is shown correctly. So it's supported, but not to the full extent.

You can treat it as a bug or enhancement, but treat it please.
It's 10+ years old functionality and used widely in DWH.