Skip to Content
0
Former Member
Oct 26, 2011 at 09:55 AM

Can these Oracle commands substitute BRTools Table Reorgan. ?

66 Views

- 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.