| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: free up datafile space problem ???
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 <ORACLE-L_at_fatcity.com>
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: jonathan_at_jlcomp.demon.co.uk
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: ListGuru_at_fatcity.com (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). Received on Tue Aug 07 2001 - 16:10:50 CDT
 |
 |