RE: Index Partition Info View

From: Jonathan Lewis <>
Date: Mon, 3 Feb 2014 22:33:35 +0000
Message-ID: <CE70217733273F49A8A162EE074F64D901DDA2E0_at_exmbx05.thus.corp>

I can never remember the various view names, so I query the data dictionary. In your case I would have done:

select view_name from all_views where view_name like 'ALL%PART%IND5'

Then repeated for 'ALL%IND%PART%' if necessary.

Jonathan Lewis

From: [] on behalf of Uzzell, Stephan [SUzzell_at_MICROS.COM] Sent: 03 February 2014 21:10
Cc: Uzzell, Stephan
Subject: Index Partition Info View

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?


Stephan Uzzell

Received on Mon Feb 03 2014 - 23:33:35 CET

Original text of this message