-
hi,
How do you find out if a partitioned table has a global index or a local index?
-
Export the table with indexes=y and rows=n. Check the .dmp file.
-
How/why the dmp file? I thought you could not look into the dmp file.
Isn't there a dba view or V$ table that can give that information?
-
A .dmp file cannot be opened if it contains table data, if it only has text, it can be opened. Check INDEX_TYPE in DBA_INDEXES for the index. It may be there.
-
-
LOCAL INDEX-GLOBAL INDEX
Hi, 22nd April 2001 17:57 hrs chennai
From the ALL_PART_INDEXES you can find out if a partitioned table has a global index or a local index.
LOCALITY column Indicates whether this partitioned index is LOCAL or GLOBAL
ALIGNMENT column 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
|