Thursday 12 January 2012

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

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 control file. 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.

No comments:

Post a Comment