Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Resetting highwatermark

Re: Resetting highwatermark

From: Phil Cook <pncook_at_worldnet.att.net>
Date: 1997/09/20
Message-ID: <5vvcm7$dsq@bgtnsc02.worldnet.att.net>#1/1 







Brian,



The only way to reset the highwater mark is by truncating or dropping 
the table.  Sounds like you are doing a full table scan, is the id field
indexed ?  



Phil Cook



Brian Rasmusson <br_at_belle.dk> wrote in article
<3422392C.1CA515AE_at_belle.dk>...


> Hi,

> 

> is it possible to reset the highwatermark of a table? I cannot drop

> or truncate the table as it is in use constantly.

> 

> 

> 

 
Received on Sat Sep 20 1997 - 00:00:00 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US