Re: Index Partition Info View
From: Andreas Piesk <a.piesk_at_gmx.net>
Date: Mon, 03 Feb 2014 22:24:16 +0100
Message-ID: <52F00900.20109_at_gmx.net>
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?
Date: Mon, 03 Feb 2014 22:24:16 +0100
Message-ID: <52F00900.20109_at_gmx.net>
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
Regards,
-ap
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Feb 03 2014 - 22:24:16 CET