Merge Partition With Update Indexes Clause Keep The First Index Partition Name (Doc ID 1092683.1)

Last updated on FEBRUARY 02, 2017

Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 10.2.0.5.0 - Release: 10.1 to 10.2
Information in this document applies to any platform.

Symptoms

Merge partition with update indexes clause keeps the first index partition name
whereas the table partition keeps the second partition name.

Testcase:

CREATE TABLE four_seasons
(
one DATE,
two VARCHAR2(60),
three NUMBER
)
PARTITION BY RANGE ( one )
(
PARTITION quarter_one
VALUES LESS THAN ( TO_DATE('01-apr-1998','dd-mon-yyyy'))
TABLESPACE users,
PARTITION quarter_two
VALUES LESS THAN ( TO_DATE('01-jul-1998','dd-mon-yyyy'))
TABLESPACE users,
PARTITION quarter_three
VALUES LESS THAN ( TO_DATE('01-oct-1998','dd-mon-yyyy'))
TABLESPACE users,
PARTITION quarter_four
VALUES LESS THAN ( TO_DATE('01-jan-1999','dd-mon-yyyy'))
TABLESPACE users
);

CREATE INDEX i_four_seasons_l ON four_seasons ( one,two )
LOCAL ;


ALTER TABLE four_seasons MERGE PARTITIONS quarter_one, quarter_two
INTO PARTITION quarter_two UPDATE INDEXES;


select segment_name,PARTITION_NAME from dba_segments where segment_name = 'I_FOUR_SEASONS_L' or segment_name = 'FOUR_SEASONS'

FOUR_SEASONS,QUARTER_TWO
FOUR_SEASONS,QUARTER_THREE
FOUR_SEASONS,QUARTER_FOUR
I_FOUR_SEASONS_L,QUARTER_ONE
I_FOUR_SEASONS_L,QUARTER_THREE
I_FOUR_SEASONS_L,QUARTER_FOUR

Changes

Two partitions of a table are merged.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms