RE: Index Partition Info View
From: Uzzell, Stephan <SUzzell_at_MICROS.COM>
Date: Mon, 3 Feb 2014 21:17:20 +0000
Message-ID: <5a6fc6c537524c36ba5d6ddc5d0e7df0_at_USMAIL2K1303.us.micros.int>
DBA_PART_INDEXES. Should have searched just a bit longer before I went to the email.
Date: Mon, 3 Feb 2014 21:17:20 +0000
Message-ID: <5a6fc6c537524c36ba5d6ddc5d0e7df0_at_USMAIL2K1303.us.micros.int>
DBA_PART_INDEXES. Should have searched just a bit longer before I went to the email.
Stephan Uzzell
From: Uzzell, Stephan
Sent: Monday, 03 February, 2014 16: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 - 22:17:20 CET