Oracle DBA, How To, Error, Cause and Action

ORA-02494: invalid or missing maximum file size in MAXSIZE clause

ORA-02494: invalid or missing maximum file size in MAXSIZE clause




Cause: UNLIMITED was not specified, or an invalid integer value was specified, for the MAXSIZE clause in the DATAFILE file list. The MAXSIZE value cannot be smaller than the SIZE value.




Action: Use correct syntax.