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.

No comments:

Post a Comment

Thanks for your comment.