ORA-02142: missing or invalid ALTER TABLESPACE option



ORA-02142: missing or invalid ALTER TABLESPACE option..

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-13626: The specified object string is not valid for task string.

1 Answers  


NNL-00569: domain_hint <domain_name> <NS_name> <NS_Addr> : Provide hint of a nameserver for a given domain

1 Answers  


ORA-14020: this physical attribute may not be specified for a table partition

1 Answers  


UDE-00050: Unable to setup parameter processing.

1 Answers  


ORA-32014: error processing parameter "string" from the SPFILE restore image

1 Answers  






DRG-10549: length of the object name string exceeded the limit

1 Answers  


ORA-22886: scoped table "string" in schema "string" is not an object table

1 Answers  


IMP-00095: Resumable parameters ignored -- current session not resumable

1 Answers  


ORA-29520: name string resolved to a class in schema string that could not be accessed

1 Answers  


DRG-12014: This document is very big - continue operation?

1 Answers  


ORA-29340: export file appears to be corrupted: [string] [string] [string]

1 Answers  


NNO-00807: End of Fetch: OCI_NO_DATA

1 Answers  


Categories