I have deleted more than 50 million records along with table’s partitions for the previous year.
now I'm trying to shrink datafile with more than 10GB free space but still unable to delete due to
ORA-03297: file contains used data beyond requested RESIZE value.
How can we shrink these datafile or otherwise what is the best way to delete huge amount of records and get additional space in HD
Thanks and best regards