Re: global index - composite partitions

On Mon, Nov 17, 2008 at 3:47 AM, Ujang Jaenudin <ujang.jaenudin_at_gmail.com> wrote:
> here I'm trying to create global index with subpartitions:
>
> create index idx_g_pvc on pvc(AN,EVD,ETI,ES)
> partition by range(EVD)
> subpartition by hash(AN) subpartitions 512
> (PARTITION p0106 VALUES LESS THAN (TO_DATE('01-01-2006', 'DD-MM-YYYY')),
> PARTITION p0206 VALUES LESS THAN (TO_DATE('01-02-2006', 'DD-MM-YYYY')),
> .............
> PARTITION p9999 VALUES LESS THAN (MAXVALUE)
> ) ;
>
>
> this always given error during index creation :(

That is because it is not possible.
"Oracle offers two types of global partitioned index: range partitioned and hash partitioned"
http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/partconc.htm#sthref2611

Subpartitioning of indexes is only available with local indexes.

-- 
Regards,
Greg Rahn
http://structureddata.org
--
http://www.freelists.org/webpage/oracle-l