Unable to view/edit table source with sub-partitions

[harrydebruin]

I'm unable to view or edit tables that contain subpartitions. The subpartitioned tables show as standard tables.

Single level partitioned tables show and work fine within the GUI. But subpartitioed tables don't.

Can someone look at this and fix

Here's is the source for the table:

CREATE TABLE "PRIU"."TOT_ELEC"
( "UOW_METER_ID" NUMBER(20,0) NOT NULL,
"CLIENT" VARCHAR2(30) NOT NULL,
"METER_NUMBER" VARCHAR2(10) NOT NULL,
"READING_TAKEN_DATE" DATE NOT NULL,
"READING_TAKEN_YEAR" NUMBER(4,0) NOT NULL,
"READING_TAKEN_MONTH" NUMBER(2,0) NOT NULL,
"READING" NUMBER(10,0),
"TARIFF_REGISTER" VARCHAR2(2) NOT NULL,
"QUALITY_FLAG" VARCHAR2(2) NOT NULL,
"DATE_OF_RECEIPT" DATE NOT NULL,
"DATE_RECORD_CREATED" DATE NOT NULL
)
TABLESPACE "USERS"
PARTITION BY RANGE ("READING_TAKEN_YEAR")
SUBPARTITION BY LIST ("READING_TAKEN_MONTH")
SUBPARTITION TEMPLATE (
SUBPARTITION "M01" values ( 1 ) TABLESPACE "USERS" ,
SUBPARTITION "M02" values ( 2 ) TABLESPACE "USERS" ,
SUBPARTITION "M03" values ( 3 ) TABLESPACE "USERS" ,
SUBPARTITION "M04" values ( 4 ) TABLESPACE "USERS" ,
SUBPARTITION "M05" values ( 5 ) TABLESPACE "USERS" ,
SUBPARTITION "M06" values ( 6 ) TABLESPACE "USERS" ,
SUBPARTITION "M07" values ( 7 ) TABLESPACE "USERS" ,
SUBPARTITION "M08" values ( 8 ) TABLESPACE "USERS" ,
SUBPARTITION "M09" values ( 9 ) TABLESPACE "USERS" ,
SUBPARTITION "M10" values ( 10 ) TABLESPACE "USERS" ,
SUBPARTITION "M11" values ( 11 ) TABLESPACE "USERS" ,
SUBPARTITION "M12" values ( 12 ) TABLESPACE "USERS" )
(PARTITION "TOT_ELEC_2008" VALUES LESS THAN (2009)
TABLESPACE "USERS" LOGGING COMPRESS ) ;

Cheers,
Harry

 

[harrydebruin]

Using version 7.1.5 of PL/SQL Developer.

Cheers,
Harry

 

[Marco Kalter]

There is indeed no explicit support for subpartitions. This is planned for 8.0.