RE: Index Partition Info View
From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 3 Feb 2014 22:33:35 +0000
Message-ID: <CE70217733273F49A8A162EE074F64D901DDA2E0_at_exmbx05.thus.corp>
From: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] on behalf of Uzzell, Stephan [SUzzell_at_MICROS.COM] Sent: 03 February 2014 21:10
To: oracle-l_at_freelists.org
Cc: Uzzell, Stephan
Subject: Index Partition Info View
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.
Regards
Jonathan Lewis
http://jonathanlewis.wordpress.com
_at_jloracle
From: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] on behalf of Uzzell, Stephan [SUzzell_at_MICROS.COM] Sent: 03 February 2014 21:10
To: oracle-l_at_freelists.org
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?
Thanks!
Stephan Uzzell
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Feb 03 2014 - 23:33:35 CET