RE: DELETE ROWS - how to recover disk space

From: Rekaish Bhardwaj <RekaishB@compans.com> > >oh I forgot you can also >ALTER INDEX TO CLUSTER> >because it physically re-sorts the data into a copy of the table, then >drops > >the old table. So your table is left "denser". (bit like me) > >isn't that right Obnoxio :-> I'm not saying anything. Except that ALTER FRAGMENT INIT IN another, new, empty dbspace is an even better idea. :-) ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

Obnoxio The Clown <obnoxio@hotmail.com> wrote: > > I'm not saying anything. Except that ALTER FRAGMENT INIT IN another, new, > empty dbspace is an even better idea. :-) > And what is the solution if she is running SE - unload I guess. Regards, Reinhard