How to fix the Oracle error ORA-01163: SIZE clause indicates string (blocks), but should match header string?

In this post, you’ll learn more about the Oracle ErrorORA-01163: SIZE clause indicates string (blocks), but should match header string with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-01163: SIZE clause indicates string (blocks), but should match header string

Reason for the Error ORA-01163: SIZE clause indicates string (blocks), but should match header string

The size specified in bytes in the SIZE clause of the CREATE CONTROLFILE statement does not equate to the number of blocks recorded in the header.

How to fix the Error ORA-01163: SIZE clause indicates string (blocks), but should match header string ?

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

Specify the correct filename and size ( in bytes ).