Why is ALTER TABLESPACE<name></name>COALESCE missing from a Space Manager script, when the coalesce option is selected?
Some scripts contain the call to ALTER TABLESPACE<name></name>COALESCE and others do not, when the option to coalesce/check for freespace is selected.
The ALTER TABLESPACE<name></name>COALESCE is not scripted when wait_for_freespace is scripted, because wait_for_freespace will make the coalesce call.
Space Manager is working correctly, the coalesce is not missing.
The trigger for either coalesce or wait_for_freespace is wether the tablespace can autoextend.