Re: Optimize problem on BIG table

2004-07-20 Thread Egor Egorov
"Aman Raheja" <[EMAIL PROTECTED]> wrote: > $ perror 28 > Error code 28: No space left on device > > I agree that there is not much disk space. > > THE ISSUE: I want to reclaim the disk space that should be freed because > of the millions of records I deleted. I need disk space to reclaim disk

Re: Optimize problem on BIG table

2004-07-19 Thread Brent Baisley
When you delete records, space is freed up within the table, not from the disk. Just like when you delete a file, it's not deleted, the space is just marked as available. So technically you do now have space in your table and you may be able to do inserts. I'm pretty sure the documentation says