| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re:How to find out free space below High Water Mark in table
Check out the dbms_space package owned by system.
Dick Goulet
____________________Reply Separator____________________ Author: "Daiminger; Helmut" <Helmut.Daiminger_at_KirchGruppe.de> 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: dgoulet_at_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_at_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).Received on Mon Jan 21 2002 - 11:34:58 CST
 |
 |