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

938302Apr 9 2013 — edited Apr 9 2013

The datafile users40.dbf has 50%used, and 50% free

SQL> alter database datafile '/data3/oradata/dataw1/users40.dbf' resize 3000M;
alter database datafile '/data3/oradata/dataw1/users40.dbf' resize 3000M
*
ERROR at line 1:
ORA-03297: file contains used data beyond requested RESIZE value

SQL>
Regards,

Locked Post

New comments cannot be posted to this locked post.

Locked on May 7 2013

Added on Apr 9 2013

#general-database-discussions

6 comments

16,323 views