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-18009: one or more outline system tables do not exist

1 Answers  


ORA-06549: PL/SQL: failed to dynamically open shared object (DLL): string

2 Answers  


ORA-26721: enqueue of the LCR not allowed

1 Answers  


ORA-09213: slgfn: error fabricating file name

1 Answers  


ORA-07258: spdcr: fork error, unable to create process.

1 Answers  






NNL-00049: Output in string cannot be renamed to string

1 Answers  


ORA-22896: cannot have both scope and referential constraint on REF column "string"

1 Answers  


LSX-00265: attribute "~1S" value "~2S" is wrong (must be "~3S")

1 Answers  


ORA-27370: job slave failed to launch a job of type EXECUTABLE

1 Answers  


ORA-34897: (PPMONTHS01) Blank lines are not allowed in the MONTHNAMES option.

1 Answers  


SQL*Loader-00419: input datatype for column string is not supported when loading varrays

1 Answers  


PLS-00402: alias required in SELECT list of cursor to avoid duplicate column names

2 Answers  


Categories