Re: Chunk really full??? Puzzling . . .

In article <340C5BE4.E68C97D5@echonyc.com>, Cosmo Lee <*N, O, -, S, P, A, M*cosmo@echonyc.com> wrote: >Well, I've just deleted a large amount of rows from the table, which >reside in the chunk in question. Still the free space shows 0. So >what's with that??? The chunk definitely has free space in it - we can >definitely insert rows into the table, but the chunk is showing 0 free >space???? > >Any clues? And in an earlier posting, he also wrote: >> The only thing that I can think of is that at some point all of the >> chunk was allocated, then some rows were deleted. But the extents >> are >> still allocated for the table and not shown as being free even though >> rows have been deleted from the table. If this is the case, how does >> one find out the "real" free space in a chunk? Same answer as before. The space that you freed remains allocated to the tablespace. onstat reports as free space only the amount that hasn't been assigned to a tablespace. To reclaim it for other purposes, dump, drop and reload the table. To find out how much of the actual tablespace is not being used by the table (but remains unavailable for other tables), consult TFM concerning oncheck. Jim -- W. Jim Jordan, Nortel, Stop 314 Qualicum, PO Box 3511 Stn C, Ottawa, ON K1Y 4H7 Canada I do not speak for Nortel. Unsolicited commercial or bulk e-mail may attract an invoice.