INDEX REBUILD !!!!!!!!!!!!!!!!!!!!!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: INDEX REBUILD !!!!!!!!!!!!!!!!!!!!!

  1. #1
    Join Date
    Feb 2001
    Posts
    290
    Hello All,
    I have to rebuild some of the indexes ( which are big in size ), in version 8.0.4 , I am planning to use

    alter index ADMINUSER.I_SHADDR1 rebuild unrecoverable tablespace SHOPIDX storage ( initial 48046080
    next 12011520
    pctincrease 0
    minextents 1
    maxextents 100)
    pctfree 0 ;

    In the above syntax , will UNRECOVERABLE is valid ????
    or can i use NOLOGGING ???

    And What happens if the Index rebuild fails , will the old index still exists ???


    Thanks,
    Madhu



  2. #2
    Join Date
    Aug 2001
    Posts
    267
    Still the old index will be good if the rebuild fails, better not to try with nologging option ..
    Raghu

  3. #3
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    In 8i RECOVERABLE/UNRECOVERABLE is replaced by LOGGING/NOLOGGING. Not sure about 8.

    Sanjay

  4. #4
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    Interesting extent sizes... I foresee fragmentation in your future.
    OCP 8i, 9i DBA
    Brisbane Australia

  5. #5
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    If ur using version 8 and above its unrecoverable and if its version 7.3 then its nologing.

    cheese
    anandkl
    anandkl

  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    Originally posted by anandkl
    If ur using version 8 and above its unrecoverable and if its version 7.3 then its nologing.

    cheese
    anandkl
    itīs the other way round

  7. #7
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    i am sorry
    anandkl

  8. #8
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    uh thatīs ok everyone make mistakes! dont need to sorry

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