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.

Error Type: ORA

• Additional information for ORA-02142: missing or invalid ALTER TABLESPACE option02142
Discussions and solutions for Oracle Database Error ORA-02142: missing or invalid ALTER TABLESPACE option Developer anwers for Oracle Database Error ORA-02142: missing or invalid ALTER TABLESPACE option FAQs for ORA-02142: missing or invalid ALTER TABLESPACE option search others tips for ORA-02142: missing or invalid ALTER TABLESPACE option