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

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

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

DRG-13000: error while adding or removing a sub lexer

1 Answers  


ORA-19501: read error on file "string", blockno string (blocksize=string)

1 Answers  


LCD-00114: illegal boolean response [string]

1 Answers  


ORA-39959: invalid warning number (string)

1 Answers  


PLS-00328: A subprogram body must be defined for the forward declaration of string.

1 Answers  






NNL-00914: Forwarding desired on server queries: string

1 Answers  


ORA-00024: logins from more than one process not allowed in single-process mode

1 Answers  


ORA-29317: datafile string does not exist

1 Answers  


ORA-14083: cannot drop the only partition of a partitioned table

1 Answers  


QSM-02059: join may produce duplicate rows in mv

1 Answers  


ORA-26022: index string.string was made unusable due to:

1 Answers  


PLS-00737: LIBRARY file specification exceeds the maximum allowed length

1 Answers  


Categories