indexes on a partitioned table
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: indexes on a partitioned table

  1. #1
    Join Date
    Apr 2001
    Location
    Berlin
    Posts
    65

    Exclamation

    hi,
    How do you find out if a partitioned table has a global index or a local index?

  2. #2
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    Export the table with indexes=y and rows=n. Check the .dmp file.

  3. #3
    Join Date
    Apr 2001
    Location
    Berlin
    Posts
    65
    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?

  4. #4
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    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.

  5. #5
    Join Date
    Apr 2001
    Location
    Berlin
    Posts
    65
    thanks Halo

  6. #6
    Join Date
    Mar 2000
    Location
    Chennai.Tamilnadu.India.
    Posts
    658

    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
  •  


Click Here to Expand Forum to Full Width