-
I have a partitioned table that has indexes. I want to finf out if the indexes are normal or global. I checked the index_type column of dba_indexes and it say normal.
Does that mean the indexes are global or local?
-
It only means it is B*tree index type. For information on partitioning, search the column PARTITIONED in DBA_/ALL_/USER_INDEXES or check the DBA_PART_INDEXES view.
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
I checked and I could not find the column that contains that information. Can you please tell me the column name under
dba_part_indexes where I can find if the indexes are global or local?
Thanks
-
Check the column DBA_PART_INDEXES.LOCALITY
hth,
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
Local-Global-Prefixed-Non-Prefixed
Hi, 22nd April 2001 17:04 hrs chennai
Use
ALL_PART_INDEXES====>
LOCALITY column which tells Indicates whether this partitioned index is LOCAL or GLOBAL
ALIGNMENT Columns Indicates whether this partitioned index is PREFIXED or NON-PREFIXED
Cheers
Padmam
Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|