Global Partitioned Indexes in Table Window

[cassiusdrow]

The table window in PL/SQL Developer 15 does not handle global partitioned indexes at all. It does not display their partitions anywhere and the "View SQL" button creates them as local indexes using the table's partitioning method. A global partitioned index is a global index that uses a different partitioning method from the table. For example, this table is partitioned by the paid_dt column, but index trans_ix3 is a global partitioned index on the earn_dt column:

CREATE TABLE trans_t
   (trans_id NUMBER NOT NULL,
    paid_dt DATE NOT NULL,
    earn_dt DATE NOT NULL)
   PARTITION BY RANGE (paid_dt)
   (PARTITION year_2021 VALUES LESS THAN (TO_DATE( '01/01/2022', 'MM/DD/YYYY')),
    PARTITION year_2022 VALUES LESS THAN (TO_DATE( '01/01/2023', 'MM/DD/YYYY')),
    PARTITION year_2023 VALUES LESS THAN (TO_DATE( '01/01/2024', 'MM/DD/YYYY')));

CREATE INDEX trans_ix1 ON trans_t (trans_id) GLOBAL;
CREATE INDEX trans_ix2 ON trans_t (paid_dt) LOCAL;
CREATE INDEX trans_ix3 ON trans_t (earn_dt) GLOBAL
   PARTITION BY RANGE (earn_dt)
   (PARTITION year_2020 VALUES LESS THAN (TO_DATE( '01/01/2021', 'MM/DD/YYYY')),
    PARTITION year_2021 VALUES LESS THAN (TO_DATE( '01/01/2022', 'MM/DD/YYYY')),
    PARTITION year_2022 VALUES LESS THAN (TO_DATE( '01/01/2023', 'MM/DD/YYYY')),
    PARTITION year_9999 VALUES LESS THAN (MAXVALUE));

ALTER TABLE trans_t ADD CONSTRAINT trans_pk PRIMARY KEY (trans_id);

The table window also does not include storage clauses, such as TABLESPACE, for local partitioned indexes.

 

[Marco Kalter]

This is on the list of enhancement requests.