Home » RDBMS Server » Server Administration » how to find Index is local or global
how to find Index is local or global [message #279305] Wed, 07 November 2007 12:57 Go to next message
DRDBA
Messages: 20
Registered: March 2007
Junior Member
Hello all.
how to find Index is local or global
Re: how to find Index is local or global [message #279312 is a reply to message #279305] Wed, 07 November 2007 14:29 Go to previous message
Frank Naude
Messages: 4507
Registered: April 1998
Senior Member
Look at the "locality" column in dba_part_indexes:

SELECT owner, index_name, locality FROM dba_part_indexes;

Previous Topic: Uninstalled Oracle
Next Topic: spfile vs pfile.
Goto Forum:
  


Current Time: Thu Mar 30 13:28:31 CDT 2017

Total time taken to generate the page: 0.07047 seconds