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

LSX-00280: duplicate ID "~S"

1 Answers  


ORA-02153: invalid VALUES password string

1 Answers  


ORA-01664: Transaction which has expanded the Sort Segment has aborted

1 Answers  


NNL-00918: Time until server restart: string

1 Answers  


TNS-01184: Listener rejected registration or update of service handler "string"

1 Answers  






NNL-00284: Scheduled cache checkpoint to occur in string

1 Answers  


ORA-06017: NETASY: message receive failure

1 Answers  


ORA-40206: invalid setting value for setting name string

1 Answers  


LPX-00321: None of the output method (DOM, SAX, Stream) is selected

1 Answers  


DRG-50858: OCI error: string

1 Answers  


ORA-01097: cannot shutdown while in a transaction - commit or rollback first

1 Answers  


PLS-00331: illegal reference to string

1 Answers  


Categories