HomeOracleOracle Error ORA-14284: one or more of table’s subpartitions reside in a read-only tablespace

Oracle Error ORA-14284: one or more of table’s subpartitions reside in a read-only tablespace

Oracle Error Message

ORA-14284: one or more of table’s subpartitions reside in a read-only tablespace

Reason for the Error

User issued ALTER TABLE statement attempting to modify an existing VARCHAR2 (or VARCHAR) column to be of type CHAR (or CHARACTER), increase length of an existing CHAR (or CHARACTER) column, or add a column with user-specified default for a table one or more subpartitions of which reside in read-only tablespaces, which is illegal

Solution

Avoid performing aformentioned operations on a partitioned table one or more subpartitions of which reside in read-only tablespaces

Share:

Leave A Reply

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

You May Also Like

Oracle Error Message CLSGN-32767: Internal error. Reason for the Error An unexpected error occurred. Solution Examine the message(s) that accompany...
Oracle Error Message CLSGN-00211: OCR batch operation failed. string Reason for the Error Setting a set of Oracle Cluster Registry...
Oracle Error Message CLSGN-00210: failed to get value for OCR key “string”. string Reason for the Error It was not...