Re: Local Prefix Index on Partioned Table ?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 16 Mar 2004 16:54:58 +0000 (UTC)
Message-ID: <c37bh2$scb$1@titan.btinternet.com>

Notes in-line

-- 
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

April 2004 Iceland
June  2004      UK - Optimising Oracle Seminar


"rc" <rc_at_spam.com> wrote in message
news:b7ae50hr59mv6lmil6ajdhvdnie7kmnk9q_at_4ax.com...


> Hi

>

> Can some one clear up one point, am I allowed to have more than

> one local index on a partioned table. I was reading some docs on

> builder.com and it seems to state that you can only have once local

> index per table


There is no special limit to the number of locally partitioned
indexes that you can have on a partitioned table.



>

> Oracle 8.1.7.4 Solaris 8

>

> Thanks

>

Received on Tue Mar 16 2004 - 10:54:58 CST