datafile's high water mark...

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: 2000/03/23
Message-ID: <38da6f34.247695903@news.earthlink.net>#1/1

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