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: 4502
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: Mon Dec 05 11:09:41 CST 2016

Total time taken to generate the page: 0.10481 seconds