How to fix the Oracle error ORA-01136: specified size of file string (string blocks) is less than original size of string blocks?

In this post, you’ll learn more about the Oracle ErrorORA-01136: specified size of file string (string blocks) is less than original size of string blocks with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-01136: specified size of file string (string blocks) is less than original size of string blocks

Reason for the Error ORA-01136: specified size of file string (string blocks) is less than original size of string blocks

A file size was specified in the AS clause of ALTER DATABASE CREATE DATAFILE, and the size was smaller the the size needed

How to fix the Error ORA-01136: specified size of file string (string blocks) is less than original size of string blocks ?

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

Create the file with a larger size.