SQL Language (MOSC)

MOSC Banner

specify index partition by date, not by name?

edited Oct 20, 2022 7:15AM in SQL Language (MOSC) 8 commentsAnswered

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:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center