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

QSM-02025: no aggregate functions

1 Answers  


ORA-32018: parameter cannot be modified in memory on another instance

1 Answers  


RMAN-06038: recovery catalog package detected an error

1 Answers  


ORA-08466: raw buffer length string is too short for string

1 Answers  


TNS-12550: TNS:syntax error

1 Answers  






IMG-00846: adjacency matrix allocation failed

1 Answers  


ORA-07741: slemop: $OPEN failure

1 Answers  


ORA-12664: Services required by server not available on the client

1 Answers  


NNL-00993: Auto-refresh failure retry expiration: string

1 Answers  


TNS-00515: Connect failed because target host or object does not exist

1 Answers  


RMAN-10037: RPC anomaly detected on channel string, upinblt=number

1 Answers  


RMAN-06540: tablespace string will be excluded from future whole database backups

1 Answers  


Categories