Re: Index Partition Info View

From: Andreas Piesk <a.piesk@xxxxxxx>
To: SUzzell@xxxxxxxxxx, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
Date: Mon, 03 Feb 2014 22:24:16 +0100

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
--
//www.freelists.org/webpage/oracle-l

Follow-Ups:
- ora-1555 on physical standby (no active data guard)
  - From: Laimutis . Nedzinskas

References:
- Index Partition Info View
  - From: Uzzell, Stephan

Other related posts:

» Index Partition Info View- Uzzell, Stephan
» RE: Index Partition Info View- Uzzell, Stephan
» Re: Index Partition Info View - Andreas Piesk
» RE: Index Partition Info View- Jonathan Lewis