Friday, 16 March 2012

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