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?