- make sure the tablespace is Auto Segment Space Management (ASSM)
- ALTER TABLE table_name ENABLE ROW MOVEMENT;
- ALTER TABLE table_name SHRINK SPACE COMPACT;
- ALTER TABLE table_name SHRINK SPACE;
Can these Oracle commands substitute the BRTools Table Reorgan. function ?
Do they ( I meant these 3 commands vs BRTools Table Reorgan. function ) do the same or similar things to us ?
Or they are substantially different ?
My colleague did SAP data archive then I tried to execute BRTools Table Reorgan. but got SAP UNIX system hang.
Thus, I have to find another way to release the free space from the archived table.
If these Oracle command can release a table's free space to us in an online mode, I will consider to use it instead.