Results 1 to 5 of 5
  1. #1
    Join Date
    May 2011
    Posts
    2

    Unanswered: Effects Of Ongoing Reorg Killed Forcefully.

    Hello All,

    Buen Día.......

    Would like to know whats the difference between the below two situation where an ongoing reorg was forcefully killed(forcing the application running the REORG command.)

    1> ONGOING ONLINE REORG BEING FORCED.

    2> ONGOING OFFLINE REORG BEING FORCED.

    Thanks a Ton......

  2. #2
    Join Date
    Oct 2007
    Posts
    246
    1) ongoing online reorg being forced : Fully logged and will be rollbacked you have the option to RESUME the online reorg.

    2) ongoing offline reorg being forced : Sort , build phases can be rolledback but once in goes to replace phase it has to complete reorg.

    regds
    Paul

  3. #3
    Join Date
    May 2011
    Posts
    2
    Thank you very much for replying.........

    But i was wondering if these senarios have different effect on the indexes present on the table.

    Regards,
    Last edited by bharatendra; 06-08-11 at 04:06.

  4. #4
    Join Date
    Oct 2007
    Posts
    246
    killing offline reorg : indexes would become invalid, Online reorg : indexes has not effect i believe not sure on this.

    regds
    Paul

  5. #5
    Join Date
    Dec 2008
    Posts
    44
    anytime you kill reorg, the table being reorg-ed will get into "reorg pending" state & when you access the table, reorg will happen again...only after completing the reorg, you will be able to access 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
  •