RE: Index Partition Info View
- From: Jonathan Lewis <jonathan@xxxxxxxxxxxxxxxxxx>
- To: "SUzzell@xxxxxxxxxx" <SUzzell@xxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 3 Feb 2014 22:33:35 +0000
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
@jloracle
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] on behalf
of Uzzell, Stephan [SUzzell@xxxxxxxxxx]
Sent: 03 February 2014 21:10
To: oracle-l@xxxxxxxxxxxxx
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
Other related posts:
