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

Thread: Index question

  1. 04-08-2002, 11:15 AM #1
    farrokhp
    farrokhp is offline Senior Member
    Join Date
    Nov 2000
    Posts
    416
    If an index rebuild process blow out for some reason ( For example not enough TEMP tablespace )
    1- Does is destroy the original index as well ?
    2- Does it destroy the index analyze stats as well ?

    Please give me the accurate answer.
    An ounce of prevention is worth a pound of cure
    Reply With Quote Reply With Quote
  2. 04-08-2002, 12:45 PM #2
    KenEwald's Avatar
    KenEwald
    KenEwald is offline Senior Advisor
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    The original index is kept with it's statistics.
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need
    Reply With Quote Reply With Quote
  3. 04-08-2002, 02:11 PM #3
    farrokhp
    farrokhp is offline Senior Member
    Join Date
    Nov 2000
    Posts
    416
    Are you quiet sure ?? Even if in the middle of rebuild you reboot the computer ?
    An ounce of prevention is worth a pound of cure
    Reply With Quote Reply With Quote
  4. 04-08-2002, 02:56 PM #4
    KenEwald's Avatar
    KenEwald
    KenEwald is offline Senior Advisor
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    Yes.

    If you kill any index (re)build, via reboot or whatever, the system is returned to it's state prior to the operation.

    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need
    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