Search code examples
sybasesap-ase

Is there something similar to online redefenition in sybase?


In oracle there is something called online redefenition.

I am new to sybase and I am searching for something similar in sybase.

the job of online redefenition is to re-orgnize the space of a table but online, it means it doesnt lock the table.

I read about re-org in sybase


Solution

  • Starting with SAP ASE 15.7 ESD#2, an online reorg option was added.

    reorg rebuild <table_name> with online
    

    It's documented in the New Features Guide for that version.

    Be careful, as there is a known bug affecting ASE 15.7 SP 133 & SP 134 that can cause issues with this command.