Re: Record deleted but space still not freed.

Do an alter index to cluster to release the unused space from the tablespace or fix the extents that means have a new copy of the table with fixed extents and drop the old one. --- kh teoh <khteoh2001@yahoo.com> wrote: > Before I do record purging for a table, I keep a > copy of "oncheck -pe" > result. After I purged the records. I keep another > copy of "oncheck > -pe". Although there has been many records being > deleted from the > table. Why there is no different on the output(free > size column) from > "oncheck -pe"(before purge and after purge) for that > particular table > ? The space will only be released when I do a > dbexport, drop the table > then dbimport the table. Is there a command to > release the deleted > record's space back to the dbspace pool ? Rather > then doing the > dbexport/dbimport task. > > And also there are many free gaps in between the > tables in the > "oncheck -pe" output. Will it affect the performance > ? How to get rib > of the gaps(defragment) ? __________________________________ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com sending to informix-list