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



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

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-02424: potential circular view references or unknown referenced tables

1 Answers  


ORA-13356: adjacent points in a geometry are redundant

1 Answers  


SQL*Loader-00434: Can not load LOB/XML in a nested table along with the parent table.

1 Answers  


ORA-02789: Maximum number of files reached

1 Answers  


DRG-50923: could not rewrite PL/SQL for execution

1 Answers  






ORA-06720: TLI Driver: SID lookup failure

1 Answers  


DRG-10511: index string does not exist or is incomplete

1 Answers  


TNS-00241: Connection Manager: Logging is now OFF

1 Answers  


PCC-02402: Pro*C option OBJECTS=YES is required when using the object cache

1 Answers  


ORA-30089: missing or invalid <datetime field>

1 Answers  


NNL-00001: request argument "string" is invalid

1 Answers  


RMAN-06570: datafile number switched to datafile copy "string"

1 Answers  


Categories