Oracle Solution for Error ora-03297

Solution for Oracle Error ORA-03297

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

What triggered the Error:

Some portion of the file in the region to be trimmed is currently in use by a database object

What should we do to fix it:

Drop or move segments containing extents in this region prior to resizing the file, or choose a resize value such that only free space is in the trimmed.