Perhaps this would be very simple for you, could anyone give Corrections to this problem.
Two tables (Table_x and Table_y) write to a partition called Test_Partition200604
The objective is to truncate the data form these two tables (which are specific to the partition) and then reclaim space
Commands used are:
Alter table Table_x truncate partition Test_Partition200604 update global indexes;
Alter table Table_y truncate partition Test_Partition200604 update global indexes;
Alter database datafile '/u02/oradata/MySystem/db02/MySystem_TestPartition200604.dbf' resize 1100M;
(the first two commands the tables were successfully truncated)
- The Resize command fails and displays the following error message:
ERROR at line 1:
ORA-03297: file contains used data beyond requested RESIZE value
I have found the observation as :
The tablespace map is checked and we find a block is still occuppied in the initial space; how do we remove this block id so the truncate will truly be successful.
Thanks to everyone.