How to fix the Oracle error ORA-19665: size string in file header does not match actual file size of string?

In this post, you’ll learn more about the Oracle ErrorORA-19665: size string in file header does not match actual file size of string with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-19665: size string in file header does not match actual file size of string

Reason for the Error ORA-19665: size string in file header does not match actual file size of string

The size of the file as indicated in the file header does not match the true size of the file. The two differing sizes are shown in units of logical blocks.

How to fix the Error ORA-19665: size string in file header does not match actual file size of string ?

You can fix this error in Oracle by following the below steps

This file is not usable – it has most likely been truncated.