Oracle database error code ORA-03297 – file contains used data beyond requested RESIZE value

Oracle Database Error Code ORA-3297 Description :
file contains used data beyond requested RESIZE value
Error Cause:
Some portion of the file in the region to be trimmed is currently in use by a database object

How to Solve :
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.


Filed under: How to Solve, Oracle 10g, Oracle 11g, Oracle 9i, Oracle Error Codes     Etiketler:, , , , , , , , , , , , ,
No Comment Yet   
«
»