Hi Folks;
I did a small test between "alter table move" and "alter table shrink space".
I dont understand why the results are diffrent between alter table move and shrink.Shrink seem more powerful.
I have two questions:
1-)Does "Shrink" and "Alter table move" both returns the space above hwm to tablespace?
2-)Why the results are diffrent between alter table move and shrink?
I used this query:
select blocks "Ever Used", empty_blocks "Never Used", num_rows "Total rows"
from user_tables where table_name=..
1-)After deletion:
Ever used Never Used
1091 61
2-)After, alter table move:
Ever used Never Used
652 116
3-)After Shrink
Ever used Never Used
632 24
Note: I tested them seperately..