Datafile Resize is not happening
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 |