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

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

Hybrid View

  1. 02-19-2002, 04:07 PM #1
    mrvajrala
    mrvajrala is offline Senior Member
    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


    Reply With Quote Reply With Quote
  2. 02-19-2002, 04:14 PM #2
    raghud
    raghud is offline Senior Member
    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
    Reply With Quote Reply With Quote
  3. 02-19-2002, 10:25 PM #3
    SANJAY_G's Avatar
    SANJAY_G
    SANJAY_G is offline Senior Advisor
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    In 8i RECOVERABLE/UNRECOVERABLE is replaced by LOGGING/NOLOGGING. Not sure about 8.

    Sanjay
    Reply With Quote Reply With Quote
  4. 02-20-2002, 01:03 AM #4
    grjohnson's Avatar
    grjohnson
    grjohnson is offline Senior Advisor
    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
    Reply With Quote Reply With Quote
  5. 02-20-2002, 07:05 AM #5
    anandkl
    anandkl is offline Senior Advisor
    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
    Reply With Quote Reply With Quote
  6. 02-20-2002, 07:13 AM #6
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    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
    Reply With Quote Reply With Quote
  7. 02-20-2002, 08:06 AM #7
    anandkl
    anandkl is offline Senior Advisor
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    i am sorry
    anandkl
    Reply With Quote Reply With Quote
  8. 02-20-2002, 08:16 AM #8
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    uh that´s ok everyone make mistakes! dont need to sorry
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width