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..

Answer / guest

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

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

SQL*Loader-00276: Local storage option overrides global storage.

1 Answers  


NZE-29028: Server verification failure when using SSL 2.0

1 Answers  


ORA-24395: cannot reinitialize non-existent pool

1 Answers  


ORA-02449: unique/primary keys in table referenced by foreign keys

1 Answers  


RMAN-06009: using target database controlfile instead of recovery catalog

1 Answers   HP,






LSX-00238: invalid Nmtoken "~S"

1 Answers  


ORA-00316: log string of thread string, type string in header is not log file

1 Answers  


ORA-25304: Queue Table has primary/secondary instance affinity. Cannot add buffer

1 Answers  


ORA-06608: LU6.2 Driver: Reset occurred in receive state

1 Answers  


ORA-24411: Session pool already exists.

1 Answers  


ORA-01227: log string is inconsistent with other logs

1 Answers  


ORA-02083: database name has illegal character 'string'

1 Answers  


Categories