OraFAQ Forum: Server Administration » how to find Index is local or global

Home » RDBMS Server » Server Administration » how to find Index is local or global

Wed, 07 November 2007 12:57

DRDBA
Messages: 22
Registered: March 2007

Junior Member

Hello all.
how to find Index is local or global

Wed, 07 November 2007 14:29

Frank Naude
Messages: 4580
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: Wed Sep 18 18:29:02 CDT 2024