1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

table partitioning

Discussion in 'General' started by dsub42, May 12, 2010.

  1. dsub42

    dsub42 Active Member

    Messages:
    31
    Likes Received:
    0
    Trophy Points:
    80
    I have created a list partitioned table ... 5 partitions.. I want to now add indexe's ..

    Is there any special way of adding indexes to a partitioned table? do I add an index to the table as normal and oracle works it out?
     
  2. simply_dba

    simply_dba Forum Advisor

    Messages:
    95
    Likes Received:
    5
    Trophy Points:
    140
    Location:
    Kolkata, India