specify index partition by date, not by name?
Oracle 19.
I am able to rewrite the following statement:
alter table my_table move partition part123 COMPRESS FOR QUERY HIGH;
into:
alter table my_table move partition for ( to_date(xxx) ) COMPRESS FOR QUERY HIGH;
and this works perfect. This allows GoldenGate, for example, to replicate this compression command, when the partition names are system generated (ie Interval partitioning).
Trying to do the same for the locally partitioned index, however, I cannot seem to find the correct syntax (and documentation doesn't seem to help at all here).
alter index my_index rebuild partition part123 COMPRESS ADVANCED LOW;
works fine, however, none of the following work: