Database Error Messages

ORA-01136

Specified size of file p1 (p2 blocks) is less than original size of p3 blocks.
  • p1: The file size in bytes specified in the DATAFILE command.
  • p2: The file size in number of blocks.
  • p3: The original file size in number of blocks.

Cause

The specified file size in the AS clause of the ALTER DATABASE CREATE DATAFILE statement is smaller than the size needed.


Action

Create the file with a larger size.