Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

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