Re: can you reset the highwater mark on a tablespace

Tablespaces don;t have high water marks as such. You've just been unlucky that an extent is at the end of the datafile, and you can't resize below that.

Obviously, if I knew your Oracle version, I could provide specific advice. But I don't, so I can't.

But if you've a flavour of 8i, do a select table_name from dba_tables where tablespace_name='Your tablespace'. Then work through each table in turn doing a 'alter table X move;'. That should consolidate some extents, and the resize should go more successfully.

HJR "Allan Tingey" <al_at_dont.send.junk.email> wrote in message news:3DD408B3.4080103_at_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 Fri Nov 15 2002 - 03:40:28 CST