Oracle DBA, How To, Error, Cause and Action

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

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


Cause:


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



Action:


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

No comments:

Post a Comment

Thanks for your comment.