var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: reorg a table
I have deleted lot of rows from one table, and then I need to shrink the table size by using alter index to cluster command. It failed because I did not have enough dbspace for the job.
How could I know how much free space I need for the table reorg?
Any bright idea will be welcome.
you can try:
ALTER FRAGMENT ON TABLE tablename INIT IN dbspacename_or_fragment_expression;
This will, oddly enough, work for both fragmented and non-fragmented tables and tends to be faster than CLUSTERing an index since it does not have to sort the data.
It might work - I never tryed it
there is another way Unload-Drop-Create Table-Load-Build Index-Upstat
you have to re-calculate table's extent,next extent or create by fragment for optimization
the table is very clean but it takes quite long time