Hi all,
I have a data file of 2G and the free bytes is
1,413,079, the used bytes is only 683,829. I like to
resize it. When I issue:
alter database datafile
'/orafs02/oradata/PV_A0725/ld_data05.dbf' resize
1000M, I got:
ERROR at line 1:
ORA-03297: file contains used data beyond requested
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
[EMAIL PROTECTED] 08/07/01 02:40PM
Hi all,I have a data file of 2G and the free bytes is
1,413,079, the used
Janet,
Possibly there were other tables in the tablespace using space in the datafile and
then some tables were deleted leaving the tablespace fragmented. To completely clean
the tablespace and free the space you have to export the contents of the tablespace(
all tables), drop the tables,
I just sent this to the other list...
Here is a quick script to list the tablespace/datafiles and their higwater
marks, as well as generate the resize commands;
--begin script
col blksz new_value blksz noprint;
col tablespace_name for a20 heading Tablespace|Name;
col file_name for a50 heading
ORACLE-L
[EMAIL PROTECTED]
hoo.com cc:
Sent by: Subject: free up datafile space problem
???
[EMAIL PROTECTED
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