Re: datafile's high water mark...

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: 2000/03/24
Message-ID: <38DB4883.7B45@yahoo.com>#1/1

NetComrade wrote:
>
> I am planning to backup the db (it's no longer in use) and would like
> to decrease the files to the minimum, tar and compress, does anybody
> know where I can find datafile's high water mark (so I can run a SQL
> script making something like
> slect ALTER DATABASE DATAFILE RESIZE||' <hwm>||';' from some sys_view.
>
> Thanx.
> ---------------
> In case I forgot to mention:
> We use Oracle 7.3.4 and 8.1.6 on Solaris 2.6, 2.7 boxes
> ---------------
> Andrey Dmitriev eFax: (978) 383-5892 Daytime: (917) 750-3630
> AOL: NetComrade ICQ: 11340726 remove NSPAM to email

http://www.oracledba.co.uk/tips/file_hwm.htm

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse

Received on Fri Mar 24 2000 - 00:00:00 CST