What will be the rollback plan for a table move + index rebuild operation?
From: Lok P <loknath.73_at_gmail.com>
Date: Tue, 31 May 2022 19:52:12 +0530
Message-ID: <CAKna9VZwZqT5iS2w5v+L197yh34vt5+KyScCNmf8gm4mPMog7w_at_mail.gmail.com>
As we are trying to move forward with table move+index rebuild operation to get some storage space back on a 12.1 version database. Management asks about the rollback plan just in case we see negative performance reading that table/index or while performing DML on the same table , post the table move+index rebuild operation. We don't have an exact lower environment with similar data volume and that too fragmented one to test application. So trying to understand, is there any way out here to get the exact fragmented table and index back in place as it was before?
Date: Tue, 31 May 2022 19:52:12 +0530
Message-ID: <CAKna9VZwZqT5iS2w5v+L197yh34vt5+KyScCNmf8gm4mPMog7w_at_mail.gmail.com>
As we are trying to move forward with table move+index rebuild operation to get some storage space back on a 12.1 version database. Management asks about the rollback plan just in case we see negative performance reading that table/index or while performing DML on the same table , post the table move+index rebuild operation. We don't have an exact lower environment with similar data volume and that too fragmented one to test application. So trying to understand, is there any way out here to get the exact fragmented table and index back in place as it was before?
Regards
Lok
-- http://www.freelists.org/webpage/oracle-lReceived on Tue May 31 2022 - 16:22:12 CEST