From dgoulet@vicr.com Mon, 21 Jan 2002 09:34:58 -0800 From: dgoulet@vicr.com Date: Mon, 21 Jan 2002 09:34:58 -0800 Subject: Re:How to find out free space below High Water Mark in table Message-ID: MIME-Version: 1.0 Content-Type: text/plain Check out the dbms_space package owned by system. Dick Goulet ____________________Reply Separator____________________ Author: "Daiminger; Helmut" Date: 1/21/2002 7:35 AM Hi! I deleted several thousand rows from a table, but it looks like the table is still taking up the same amount of space in the tablespace. Which it indeed does, because delete does not reset the HWM. Does anybody out there have a script that gives me the free space in a table below the high water mark? This is 8.1.7 on Sun Solaris. Thanks, Helmut How to find out free space below High Water Mark in table

Hi!

I deleted several thousand rows from a table, but it looks like the table is still taking up the same amount of space in the tablespace. Which it indeed does, because delete does not reset the HWM.

Does anybody out there have a script that gives me the free space in a table below the high water mark?

This is 8.1.7 on Sun Solaris.

Thanks,
Helmut

-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: dgoulet@vicr.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).