ORA-22856: cannot add columns to object tables
- 2 Answers
- 5431 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-38201: assert if pin during flush
ORA-12492: DBLOW cannot be changed
LPX-00300: no name in attribute set
ORA-31645: unable to read from dump file "string"
ORA-28668: cannot reference mapping table of an index-organized table
ORA-14616: table is not subpartitioned by List method
PCC-02367: This indicator variable must be declared as type short
ORA-36720: (XSALLOC01) To be used with ALLOCATE, your AGGMAP workspace object must be defined with the ALLOCMAP command.
ORA-22992: cannot use LOB locators selected from remote tables
PROT-00601: Failed to initialize ocrcheck
ORA-24323: value not allowed
TNS-04203: Trace Assistant Usage ERROR: Invalid options
Oracle Errors 
