Oracle DBA, How To, Error, Cause and Action

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

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




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




Action: 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.