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

Oracle Error Message

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

Reason for the Error

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.

Solution

Specify the correct filename and size ( in bytes ).

Share:

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

Oracle Error Message ORA-24328: illegal attribute value Reason for the Error The attribute value passed in is illegal. Solution Consult...
Oracle Error Message ORA-01346: LogMiner processed redo beyond specified reset log scn Reason for the Error LogMiner has detected a...
Oracle Error Message ORA-13241: specified dimensionality does not match that of the data Reason for the Error An error occurred...