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!

ORA-03297 Datafile resize problem

484376Feb 18 2009 — edited Feb 18 2009

Hi,

Currently we have a tablespace of 5449mb with a free space of 4233mb and used space 1216mb.

I have issued the following syntax to resize the datafile but is failing.

SQL> alter database datafile '/oracle/abc_01.dbf' resize 2500m;
alter database datafile '/oracle/abc_01.dbf'resize 2500m
*
ERROR at line 1:
ORA-03297: file contains used data beyond requested RESIZE value

I have used various sizes like 3000m,3500m ... but still the result is same.

I have observed that there are around 2500mb free extens are available continuously(dba_free_space view).

Actually before resizing i have truncated a table data of around 3G.

Could anyone explain me to resolve this issue.

Thanks,
rk.

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 18 2009

Added on Feb 18 2009

#general-database-discussions

9 comments

4,393 views