dbms_redefintion vs. table shrink
As far as I can read, the restriction for above approachs are about the same.
Use dbms_redefinition is little bit more complicated than use "alter table shrink".
However "alter table shrink" need a table-level lock, even for a very short time.
Can anyone tell me which approach give us more benifit?
Thanks,