Global Hash Partitioned Indexes

[clock]

Greetings,

I noticed today that when I create a global hash partitioned index, the GUI display for the table under indexes has Local checkmarked. Furthermore when I select 'View SQL' it has the DDL with the LOCAL keyword on it.

When I use dbms_metadata.get_ddl to extract the index DDL it has it with the GLOBAL keyword on it.

I also checked DBA_PART_INDEXES and the locality = 'GLOBAL'

Please advise.

 

[Marco Kalter]

Global partitioned indexes are currently not supported. This is on the list of enhancement requests.

 

[clock]

Thank you for confirming. Just curious, is there an estimated release version for this enhancement?