Re: How to recover dbspace after deleted all rows from large

Hi Deletes just zeros the data, it will leave the space taken up by the table as is. Assumes that you're gonna be inserting stuff - so why bother freeing space when you'll need to reclaim it anyway. To free your space you need to: If you're deleting all the rows in the table then drop/re-create the table. It's also much quicker. If you're not deleting everything then you'd have to cluster an index or alter the fragment to get your space back. >>> <shahid.mehmood@aku.edu> 02/23/00 06:53am >>> Can any one help me in recovering dbspace after delition of rows from table(s)? Thanks in advance ... Shahid Mehmood Software Designer II Information Systems Department The Aga Khan University Karachi Official:Y