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: 22
Registered: March 2007
Junior Member
Hello all.
how to find Index is local or global

Report message to a moderator

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: 4587
Registered: April 1998
Senior Member
Look at the "locality" column in dba_part_indexes:

SELECT owner, index_name, locality FROM dba_part_indexes;

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jan 11 12:56:32 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.