I have just found a command :
To rebuild :
alter table owner.table_name move;
To rebuild with new storage parameters :
alter table owner.table_name move storage (initial next etc.);
Has anybody used these commands before and know of any implications.
Thanks




Reply With Quote