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

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:42

ORA-14062：一个或多个表的分区驻留在只读表空间中,
.原因：用户发出ALTER TABLE语句试图将现有VARCHAR2（或VARCHAR）列修改为CHAR（或CHARACTER）类型，增加现有CHAR（或CHARACTER）列的长度，或者为用户指定的缺省一个或多个分区驻留在只读表空间中的表，这是非法的,
.操作：避免对分区表执行上述操作，其中一个或多个分区驻留在只读表空间中,
.

aiaiDBA

13718043309

010-86462881

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

1 个回答

相似问题