Message-Id: <10667.120860@fatcity.com> From: "Koivu, Lisa" Date: Wed, 1 Nov 2000 15:38:27 -0500 Subject: RE: HIGH WATER MARK This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C04443.B1E8337A Content-Type: text/plain; charset="iso-8859-1" Check out DBMS_SPACE. That will give you the true HWM. The only way to reset the HWM is to truncate a table. HTH Lisa Rutland Koivu Oracle Database Administrator Qode.com 4850 North State Road 7 Suite G104 Fort Lauderdale, FL 33319 V: 954.484.3191, x174 F: 954.484.2933 C: 954.658.5849 http://www.qode.com "The information contained herein does not express the opinion or position of Qode.com and cannot be attributed to or made binding upon Qode.com." -----Original Message----- From: mala singh [mailto:mala_singhm@hotmail.com] Sent: Wednesday, November 01, 2000 2:21 PM To: Multiple recipients of list ORACLE-L Subject: HIGH WATER MARK Hi DBA How can find the High water mark of table and how can remove such problem from such table. Thanks Mala _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mala singh INET: mala_singhm@hotmail.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). ------_=_NextPart_001_01C04443.B1E8337A Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: HIGH WATER MARK

Check out DBMS_SPACE.  That will give you the = true HWM.
The only way to reset the HWM is to truncate a = table. 

HTH

Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL  33319

V: 954.484.3191, x174
F: 954.484.2933
C: 954.658.5849
http://www.qode.com

"The information contained herein does not = express the opinion or position of Qode.com and cannot be attributed to = or made binding upon Qode.com."


-----Original Message-----
From: mala singh [mailto:mala_singhm@hotmail.com]
Sent: Wednesday, November 01, 2000 2:21 PM
To: Multiple recipients of list ORACLE-L
Subject: HIGH WATER MARK


Hi DBA
How can find the High water mark of table and how = can remove such problem
from such table.
Thanks

Mala





_______________________________________________________________= __________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own = public profile at
http://profiles.msn.com.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: mala singh
  INET: mala_singhm@hotmail.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