indexes on a partitioned table

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.

thanks Halo

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