Oracle Database Errors or Warnings from Error ORA-02140 to ORA-02150

SQLServerF1

 

ORA-02140: invalid tablespace name
Cause: An identifier does not follow ALTER TABLESPACE.
Action: Specify a tablespace name following ALTER TABLESPACE.
ORA-02141: invalid OFFLINE option
Cause: An option other than NORMAL or IMMEDIATE follows OFFLINE.
Action: The user must either specify no option following OFFLINE or one of the options NORMAL or IMMEDIATE.
ORA-02142: missing or invalid ALTER TABLESPACE option
Cause: A valid option was not present.
Action: Use one of the valid options: add, rename, default, online, offline, read only, read write, begin, end, no, force, retention guarantee and retention noguarantee.

ORA-02143: invalid STORAGE option
Cause: An option other than INITIAL, NEXT, MINEXTENTS, MAXEXTENTS, or PCTINCREASE was specified in the STORAGE clause.
Action: Specify only valid options.
ORA-02144: no option specified for ALTER CLUSTER
Cause: No ALTER CLUSTER options are specified.
Action: Specify one or more of the following options: pctfree, pctused, size, storage.
ORA-02145: missing STORAGE option
Cause: No STORAGE options were specified following STORAGE (
Action: Specify one or more STORAGE option between the parentheses.

ORA-02146: SHARED specified multiple times
Cause: The SHARED option was specified in a CREATE DATABASE statement multiple times.
Action: Only specify the SHARED option once.
ORA-02147: conflicting SHARED/EXCLUSIVE options
Cause: Both the SHARED and EXCLUSIVE options were specified in a CREATE DATABASE statement.
Action: Specify SHARED or EXCLUSIVE, but not both.
ORA-02148: EXCLUSIVE specified multiple times
Cause: The EXCLUSIVE option was specified in a CREATE DATABASE statement multiple times.
Action: Only specify the EXCLUSIVE option once.
ORA-02149: Specified partition does not exist
Cause: Partition not found for the object.
Action: Retry with correct partition name.
ORA-02150: invalid new tablespace name
Cause: The new tablespace name specified in ALTER TABLESPACE RENAME TO statement was invalid.
Action: Retry with a valid new tablespace name.

Above are list of Oracle Database Errors or Warnings from Error ORA-02140 to ORA-02150 received while performing certain operation against Oracle Database or related products.

What are Oracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database.  Each Oracle Database Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.

Hope this was helpful.

Thanks,
SQLServerF1 Team
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.

 

Leave a Reply

Your email address will not be published. Required fields are marked *