Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

datafile shrink

user511621Feb 14 2008 — edited Feb 15 2008
hi
so many times i have ask this question in forums but i didn't found any good workaround for this problem. i want to shrink my datafile but i m getting error because of HWM shifed to very high value plz. see the below output of my db and suggest me the workaround.

FILE# tablespace_name #Meg #Used #Free %Free
---------- ------------------------------ --------- --------- --------- --------- --------- --------------
7 TSMISC 6419.06 852.63 5566.44 86.72

SQL> SQL> alter database datafile 7 resize 1000m;
alter database datafile 7 resize 1000m
*
ERROR at line 1:
ORA-03297: file contains used data beyond requested RESIZE value


SQL> alter database datafile 7 resize 5000m;
alter database datafile 7 resize 5000m
*
ERROR at line 1:
ORA-03297: file contains used data beyond requested RESIZE value
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 14 2008
Added on Feb 14 2008
7 comments
2,347 views