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@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