ORA-01200: actual file size of string is smaller than
correct size of string blocks



ORA-01200: actual file size of string is smaller than correct size of string blocks..

Answer / guest

Cause: The size of the file as returned by the operating
system is smaller than the size of the file as indicated in
the file header and the controlfile. Somehow the file has
been truncated. Maybe it is the result of a half completed copy.

Action: Restore a good copy of the data file and do recovery
as needed.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-01916: keyword ONLINE, OFFLINE, RESIZE, AUTOEXTEND or END/DROP expected

1 Answers   CTS,


ORA-39056: invalid log file specification.

1 Answers  


SQL-02111: Heap consistency error

1 Answers  


ORA-01757: Must specify an object number

1 Answers  


NNO-00307: invalid server name "string"

1 Answers  


NNL-00257: Server-generated requests currently require authoritative answers

1 Answers  


SQL*Loader-00270: TERMINATED BY EOF valid only for CHAR or RAW datatypes

1 Answers  


ORA-16638: could not get the instance status

1 Answers  


ORA-07247: skgfrfms, skgfrnms: read error, unable to read block from database file

1 Answers  


ORA-16716: clearing parameter LOG_ARCHIVE_DEST failed

1 Answers  


LPX-00204: syntax error

1 Answers  


IMG-02009: 2FF09 - texture feature cannot be determined

1 Answers  


Categories