Oracle DBA, How To, Error, Cause and Action

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

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


Cause:


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



Action:


Create the file with a larger size.

No comments:

Post a Comment

Thanks for your comment.