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 -> can you reset the highwater mark on a tablespace

can you reset the highwater mark on a tablespace

From: Allan Tingey <al_at_dont.send.junk.email>
Date: Thu, 14 Nov 2002 13:33:55 -0700
Message-ID: <3DD408B3.4080103@dont.send.junk.email>


Hi,

I need to resize a tablespace datafile to a smaller size but the system claims that there is too much data in the file to allow the resize. There is almost no data left in the tablespace and I believe the highwater mark is preventing the operation. Is there a way to reset this value?

Thanks,

Allan Tingey
al_at_genetics.utah.edu Received on Thu Nov 14 2002 - 14:33:55 CST

Original text of this message

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