I think you may find that your 'hwm' comment is a
version dependent thing, and a restriction on RMAN
which always seems to back up to the tablespace
'hwm'.
Certainly from 8.0.5 onwards, I have reduced
file sizes before setting tablespaces readonly
by fiddling about with:
alter table move
alter index rebuild
and then resizing data files downwards.
Jonathan Lewis
Seminars on getting the best out of Oracle
Last few places available for Sept 10th/11th
See http://www.jlcomp.demon.co.uk/seminar.html
-----Original Message-----
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: 07 August 2001 21:50
its like the high water mark in a table but its at the datafile side
instead.
if any block in the datafile has ever had data in it, you can't shrink
it below that point.
hth, joe
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jonathan Lewis
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
