Partitioned Tables' DDL not shown correctly

[iratta]

Oracle DB version: 11.2.0.4
PL/SQL Developer Version 11.0.4.1774

I've noticed that, for the DDLs generated by PL/SQL developer for some partitioned tables, the partition method is missing. ie. PARTITION BY RANGE or PARTITION BY LIST or PARTITION BY HASH is missing .

I created a very basic partitioned test table. But , its DDL is shown correctly.

For for a lot of production tables, the partition method is missing.Below is a sample DDL generated by PL/SQL developer. The syntax is wrong as it doesn't show the partition method.

create table T1
(
order_type_mnemonic VARCHAR2(254 CHAR) not null,
order_source_mnemonic VARCHAR2(254 CHAR) not null,
namespace_mnemonic VARCHAR2(254 CHAR) not null,
order_seq_id NUMBER(18),
key VARCHAR2(2000) not null
)
partition by (ORDER_SEQ_ID) ----------> It should be PARTITION BY RANGE or PARTITION BY LIST or PARTITION BY HASH

Toad is showing the DDL correctly. Is this is a know issue in PL/SQL developer?

 

[Marco Kalter]

That's odd. We'll check it out.