ORA-22856: cannot add columns to object tables
- 2 Answers
- 6184 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / anil chechani
You might have not enough privileges to your tablespace, I
mean the tablespace may be 'READ ONLY'
So,I suggest check that and try to make "READ WRITE" mode
and try once again.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / guest
Cause: An attempt was made to add columns to an object
table. Object tables cannot be altered to add columns since
its definition is based on an object type.
Action: Create a new type with additional attributes, and
use the new type to create an object table. The new object
table will have the desired columns.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 1 No |
ORA-37072: (XSMCSESS00) Object workspace object has the wrong type.
NNL-00810: Queries received with no type: number
DRG-11441: gist numParagraphs string is invalid
NZE-29101: Cannot add private key bag.
KUP-11011: file string is not valid for this load operation
TNS-00291: Navigator: Enabled Interchange
ORA-19016: attributes cannot occur after element specifications
PLS-00611: right hand side can be only the variables of record type
ORA-07257: spdcr: translation error expanding program name.
RMAN-06084: the target database may not be mounted when issuing REPLICATE
ORA-03252: initial extent size not enough for LOB segment
DRG-12010: This file already exists - replace existing file?
Oracle Errors 
