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

RMAN-10007: error closing cursor

1 Answers  


IMG-00705: unsupported or corrupted input format

1 Answers  


ORA-15019: discovered duplicate path 'string' for 'string'

1 Answers  


DRG-11612: URL store: unknown host specified in string

1 Answers  


EXP-00018: datatype (number) for column string, table string.string is not supported

1 Answers  






ORA-06435: ssaio: write error, unable to write requested block to database file.

1 Answers  


LSX-00023: unknown namespace URI "~S"

1 Answers  


ORA-33098: (APABBR01) A value of 'string' is not valid for the workspace object option.

1 Answers  


RMAN-20039: format requires character when duplexing

1 Answers  


IMP-00044: unable to allocate enough memory for statement

1 Answers  


O2I-00122: Invalid filename for the INITFILE file

1 Answers  


ORA-16509: the request timed out

1 Answers  


Categories