Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Local Prefix Index on Partioned Table ?

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US