Database Administration (MOSC)

MOSC Banner

Datafile Resize is not happening

edited May 13, 2016 5:02AM in Database Administration (MOSC) 4 commentsAnswered

Hi Team

I have moved the objects from one table space to another to make datafile free blocks at the top of the file but when i resize then still it shows the below error.

We have sufficient space at the top of the datafile but still shows the below error.

SQL> ALTER DATABASE DATAFILE '+POCDATA/qtrpoc/datafile/qain0.272.902046625' RESIZE 25G ;

ALTER DATABASE DATAFILE '+POCDATA/qtrpoc/datafile/qain0.272.902046625' RESIZE 25G

*

ERROR at line 1:

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

########################

Sample of the datafile free space is below.

10 458752 459775 QAIN0_RMCORE               TRA_P_19_G                                                INDEX

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center