Re: Index Partition Info View

From: Andreas Piesk <>
Date: Mon, 03 Feb 2014 22:24:16 +0100
Message-ID: <>

On 03.02.2014 22:10, Uzzell, Stephan wrote:
> My google skills are not quite up to the challenge: is there a DBA_ (or
> other) view that shows whether an index is local or global? Anything
> quicker than dbms_metadata to grab the DDL to figure this out?

yes, there is, see ALL_PART_INDEXES.LOCALITY


Received on Mon Feb 03 2014 - 22:24:16 CET

Original text of this message