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-02330: datatype specification not allowed

1 Answers  


ORA-32139: Cannot write to the stream

1 Answers  


ORA-01575: timeout waiting for space management resource

1 Answers  


TNS-00232: Unable to setup connection

1 Answers  


ORA-13225: specified index table name is too long for a spatial index

1 Answers  






ORA-23477: unable to alter propagation mode for object group "string"."string"

1 Answers  


ORA-25242: cannot change subscriber name from string to string without FIRST_MESSAGE option

1 Answers  


TNS-12508: TNS:listener could not resolve the COMMAND given

1 Answers  


ORA-14402: updating partition key column would cause a partition change

2 Answers  


ORA-02454: Number of hash keys per block (string) exceeds maximum of string

1 Answers  


KUP-03001: fatal error during library cache pre-loading

1 Answers  


ORA-36666: (XSDPART04) workspace object is not a concat dimension.

1 Answers  


Categories