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

NZE-28806: Cannot write to the data source.

1 Answers  


ORA-26516: no push transaction acknowledgement

1 Answers  


LSX-00020: unknown type "~S"

1 Answers  


ORA-06121: NETTCP: access failure

1 Answers  


ORA-07609: szprv: $HASH_PASSWORD failure

1 Answers  






DRG-12432: configuration file string not found or unreadable

1 Answers  


ORA-00827: could not shrink sga_target to specified value

1 Answers  


ORA-12484: invalid OS label

1 Answers  


ORA-16156: LGWR archive log dependency not allowed if database is standby protected

1 Answers  


RMAN-20001: target database not found in recovery catalog

2 Answers  


ORA-26027: unique index string.string partition string initially in unusable state

0 Answers   MeritTrack,


PLS-00993: Cursor Variables cannot be passed as RPC arguments or results

1 Answers  


Categories