Wednesday 14 March 2012

ORA-14062: one or more of table s partitions reside in a read-only tablespace

ORA-14062: one or more of table s partitions 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 partitions of which reside in read-only tablespaces, which is illegal

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

No comments:

Post a Comment