Re: HIGH WATER MARK

If you are on a release of 8i that allows the 'alter table move' command you can achieve a reset of the HWM without having to export, truncate, etc. Quite handy command that was long overdue.

• Brian
  • Ron Rogers <RROGERS_at_galottery.org> wrote:
    > to remove the high water mark from a table you have to export the
    > data, truncate the table and import the data back into the table.
    > Keep in mind that the inserts into a table raise the high water mark
    > but the deletes from a table do not lower it.
    > ROR ª¿ª
    >
    > >>> mala_singhm_at_hotmail.com 11/01/00 02:21PM >>>
    > 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_at_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_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).
    >
    > --
    > Please see the official ORACLE-L FAQ: http://www.orafaq.com
    > --
    > Author: Ron Rogers
    > INET: RROGERS_at_galottery.org
    >
    > 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).
    

    ---