ORA-01136 specified size of file string ( string blocks) is less than original size of string blocks
This is an Oracle Database Server Message. This can be generated by the Oracle Database when running any Oracle program.
What is the cause of ORA-01136 from Oracle 10g ?
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 deal with ORA-01136 from Oracle 10g ?
Create the file with a larger size.
Contacting Oracle support services ?
Some messages recommend contacting Oracle Support Services to report a problem. Please go here for more information : Oracle Support.
Linked Error Messages
- ORA-01128 cannot start online backup - file string is offline
- ORA-01129 user's default or temporary tablespace does not exist
- ORA-01135 file string accessed for DML/query is offline
- ORA-01137 data file string is still in the middle of going offline
- ORA-01138 database must either be open in this instance or not at all
- ORA-01139 RESETLOGS option only valid after an incomplete database recovery
- ORA-01140 cannot end online backup - all files are offline or readonly
- ORA-01141 error renaming data file string - new file ' string ' not found
- ORA-01142 cannot end online backup - none of the files are in backup
- ORA-01143 cannot disable media recovery - file string needs media recovery
- ORA-01144 File size ( string blocks) exceeds maximum of string blocks