Resize the Storage parameter for Index creation
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Resize the Storage parameter for Index creation

  1. #1
    Join Date
    Dec 2002
    Location
    Singapore
    Posts
    27

    Resize the Storage parameter for Index creation

    Hi All,
    Can u please guide me if it is possible for me to resize the storage parameter in creating an index.Previously i had created an index using higher storage parameters say Initial Extents and Next Extent sizes.Now i want to alter these parameters ie make it lower than what i have created it.What are the implications by doing so?Is it possible in the first case.I'm trying to change it in UAT-Environment.I created the index with a very huge initial extent size now i want to reduce it by 50%.
    And one more clarification can the next extent size be 10% of Initial Size.Your suggestions would greatly help me.Please do advice.I'm working on Oracle 9i Rel.2. on HP-Unix.
    Thanks,
    Rama
    K.M.Ramakrishnan

  2. #2
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Have a look at ALTER INDEX REBUILD in the SQL manual - you can redefine the storage parameters.

    Current thinking is to have PCTINCREASE=0, INITAL=NEXT= same value for all objects in a tablespace (preferably LMT). Yes, it's OK to have 100's of extents. See: http://otn.oracle.com/deploy/availab...pdf/defrag.pdf

  3. #3
    Join Date
    Dec 2003
    Location
    Macedonia
    Posts
    4
    Hi,

    You cannot decrease the initial extent, you cannot deallocate it - so you must rebuild the index (you can do this online without locking the table).

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