I use ALTER TABLE tablename DEALLOCATE UNUSED in a 7.3.4 DB and I did
queried the unused space by calling DBMS_SPACE.UPUSED_SPACE before the
ALTER. But I still get the same number both from user_segments.bytes and
dba_free_space.bytes for the tablespace the table is using. (some of the
tables I did against to have several extents). As per Oracle manual only the
space above the high water mark can be deallocated and the position of the
high water mark can be found by calling DBMS_SPACE.UPUSED_SPACE, my problem
is what is the high water mark it doesn't seem to me any of the OUT
paramters for DBMS_SPACE.UPUSED_SPACE is about it. OR anywhere I did wrong ?
Thanks - Chuck
Received on Mon May 22 2000 - 00:00:00 CDT
