How to find if index is local or global in oracle dictionary

posted Jan 17, 2012, 1:28 PM by Sachchida Ojha   [ updated Jan 27, 2012, 4:21 PM ]
SELECT INDEX_NAME, LOCALITY FROM ALL_PART_INDEXES;
Comments