Check out the dbms_space package owned by system. Dick Goulet
____________________Reply Separator____________________ Author: "Daiminger; Helmut" <[EMAIL PROTECTED]> 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 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2653.12"> <TITLE>How to find out free space below High Water Mark in table</TITLE> </HEAD> <BODY> <P><FONT SIZE=2 FACE="Arial">Hi!</FONT> </P> <P><FONT SIZE=2 FACE="Arial">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.</FONT></P> <P><FONT SIZE=2 FACE="Arial">Does anybody out there have a script that gives me the free space in a table below the high water mark?</FONT> </P> <P><FONT SIZE=2 FACE="Arial">This is 8.1.7 on Sun Solaris.</FONT> </P> <P><FONT SIZE=2 FACE="Arial">Thanks,</FONT> <BR><FONT SIZE=2 FACE="Arial">Helmut</FONT> </P> </BODY> </HTML> -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
