ORA-22856: cannot add columns to object tables
- 2 Answers
- 4921 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 |
QSM-02121: set operator in a context not supported for fast refresh
ORA-38439: invalid operation "string"
TNS-00112: Failed to find configuration file name
ORA-27028: skgfqcre: sbtbackup returned error
ORA-26670: STREAMS option requires COMPATIBLE parameter to be string or higher
IMG-00543: invalid compressionFormat specified
DRG-50924: PL/SQL inside PL/SQL not supported
IMP-00069: Could not convert to environment national character set's handle
ORA-24051: cannot propagate object type payloads that have a REF attribute
QSM-02029: PL/SQL function invocation
ORA-09821: Numeric label is not valid
NZE-29150: DES self-test failure
Oracle Errors 
