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

ORA-13356: adjacent points in a geometry are redundant

1 Answers  


ORA-31676: illegal value for number of workers, string

1 Answers  


ORA-32639: Aggregate functions on reference MODELs are not allowed

1 Answers  


ORA-38708: not enough space for first flashback database log file

2 Answers  


ORA-00027: cannot kill current session

1 Answers  






NZE-29157: Unable to build an absolute path to the library.

1 Answers  


PROC-00012: Out of heap memory.

1 Answers  


DRG-10581: indirect datastores cannot be used with long or lob text columns

1 Answers  


PLS-00900: can't find body of unit 'string'

1 Answers  


DRG-10756: neither text indexing nor theme indexing has been selected

1 Answers  


NNC-00429: invalid octet string literal "string"

1 Answers  


ORA-16002: database already open for read-write access by another instance

1 Answers  


Categories