You are here: Home // Oracle 11g // 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 See the solution below.

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

Database version: Oracle 11g Release 2 (11.2)

Tags: ,

Leave a Reply

Copyright © 2009 Oracle Error Codes Database. All rights reserved.
Powered by WordPress.
Promotes: Dieta dla diabetyka zakłady bukmacherskie konstrukcje stalowe Meble używane Warszawa apartamenty we Wrocławiu