Re: Relocating the partitions of an index on a composite partitioned table.

From: Deepak Sharma <sharmakdeep_oracle_at_yahoo.com>
Date: Mon, 3 Oct 2005 12:46:18 -0700 (PDT)
Message-ID: <20051003194618.49177.qmail@web52815.mail.yahoo.com>

You would need to rebuild subpartitions (not partition), or am I missing something here?

create table t1
(

        emp_id          number,
        date_key        number,
        zone            char(1)

)
PARTITION BY RANGE ( date_key )

        SUBPARTITION BY LIST (zone)
                SUBPARTITION TEMPLATE (
                        subpartition P_N values ('N'),
                        subpartition P_S values ('S'),
                        subpartition P_E values ('E'),
                        subpartition P_W values ('W')
                )


(

        partition P20051003 values less than (
20051004 ),
        partition P20051004 values less than (
20051005 ),
        partition P20051005 values less than (
20051006 ),
        partition P20051006 values less than (

20051007 )
)
/

create index emp_id_ix on t1(emp_id) local;

select index_name, partition_name, subpartition_name from user_ind_subpartitions where index_name = 'EMP_ID_IX'; EMP_ID_IX P20051003 P20051003_P_N
EMP_ID_IX P20051003 P20051003_P_S
...

SQL> alter index EMP_ID_IX rebuild subpartition P20051003_P_N tablespace users01;

Index altered.

• Deepak
  • Rodd Holman <Rodd.Holman_at_gmail.com> wrote:

> Actually I just went through this exercise.
> With composite partitioned indexes, you need to do a
> drop and create.
> Rebuild will not work.
> 
> Rodd



		
__________________________________ 

Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Oct 03 2005 - 14:49:18 CDT