Shrink cascade, what happen with indexes?
553681Dec 13 2007 — edited Dec 14 2007Hi,
alter table xxx shrink cascade;
This stantement reorganize the associate indexes of table xxx too !
HWM of table it's set to min possible, but what happen with HWM of index?
The extentions are compressed, but the space it's back to tablespace?
Thanks to all.
Regards.
Francesco