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!

ORA-03297: file contains used data beyond requested RESIZE value

641098Jun 4 2008 — edited Jun 4 2008
Hi
I am working on index Tablespace which is having around 20GB of Free Space,
But when I tried to release space by resizing the datafiles it is giving me following error.

ALTER DATABASE DATAFILE '/d001/pistss_2006_01.dbf' RESIZE 3000M;
*
ERROR at line 1:
ORA-03297: file contains used data beyond requested RESIZE value


This tablespace only contain indexes in it and the tablespace has been created as segment space management Manual.
Please suggest if any one has faced such issue.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 2 2008
Added on Jun 4 2008
3 comments
1,374 views