Re Organize Table

Reorganize Table

Concept

Reorgnize tablespace is used to reclaim the space. Reorganize can be done offline(speed) or online(availability).

Re-organize Offline ( more faster than Re-organize online)

Steps

SQL> alter table mitesh.per_all_people_f move tablespace users;

SQL> alter tablespace safal;

SQL> alter table mitesh.per_all_people_f move tablespace safal;

Re-organize Online ( Slow then Re-organize offline but online )

 Can be done by using dbms_redefinition Package