Local indexes

[BWendling]

Hi,

thank you for the "compress" option when creating indexes, but where is the "local" keyword checkbox to create a local partitioned index (instead of global, which is the default)?

 

[Marco Kalter]

Support for local partitioned indexes is still on our to-do list.

 

[BWendling]

Even DBMS_METADATA does not know the difference between local and global indexes (it writes global partitioned instead, and it forgets "compress", too, in 9.2.0.4.0).

Thus I'm eagerly awaiting your solution. Which data dictionary table does define "local indexes" anyway?.

 

[whip]

The column "locality" in user/all/dba_part_indexes shows whether the index is local or global.

 

[Malte Schnack]

Is there any new status info regarding support for local partitioned indexes available?

Thanks.

 

[BWendling]

Hi Marco,

local indexes are a key feature of partitioning - used in nearly all large databases.

This issue is around two years old and could easily be implemented in a small amount of time.

Please do your professional customers a favor and implement support for local indexes soon!

Thank you.

 

[olegp]

This is major annoyance for us also.

 

[taka]

me too.

 

[Marco Kalter]

We'll give this some priority.

 

[jschmied]

Hi!

I'm voting for fixing this also...

Thanks!

PS: Changing PCTUSED for all kind of Tables does not work for me. (Put value in, APPLY, REFRESH, value is gone)

J

 

[PhilG]

Manage partitionned table is also a must for us
Thanks doing it