Oracle7 Server Messages

Contents Index Home Previous Next

02490-02499: Resizeable Datafiles

ORA-02490 missing required file size in RESIZE clause

Cause:No value was specified for the RESIZE clause.
Action:Use correct syntax.
ORA-02491 missing required keyword ON or OFF in AUTOEXTEND clause

Cause:The keyword ON or OFF was not specified for the AUTOEXTEND clause.
Action:Use correct syntax.
ORA-02492 missing required file block increment size in NEXT clause

Cause:No value was specified for the NEXT clause.
Action:Use correct syntax.
ORA-02493 invalid file increment size in NEXT clause

Cause:A non-integer value was used for the NEXT clause of the DATAFILE list.
Action:Use correct syntax.
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.
ORA-02495 cannot resize file name, tablespace name is read only

Cause:An attempt was made to resize a data file in a tablespace that is read only.
Action:Change the tablespace to read/write and retry the resize operation.


Contents Index Home Previous Next