Re: datafile's high water mark...

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: 2000/03/23
Message-ID: <953842213.4503.0.nnrp-08.9e984b29@news.demon.co.uk>#1/1

I believe that Connor McDonald has something suitable on http://www.oracledba.co.uk

If not:

select file_id, max(block_id + blocks) * block_size from dba_extents
group by file_id
then join to v$datafile or dba_data_files

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

NetComrade wrote in message <38da6f34.247695903_at_news.earthlink.net>...


>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

>

Received on Thu Mar 23 2000 - 00:00:00 CST