ORA-22856: cannot add columns to object tables
- 2 Answers
- 5494 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-19753: error writing to change tracking file
ORA-16028: new string causes less destinations than LOG_ARCHIVE_MIN_SUCCEED_DEST requires
NNF-01008: XDS attribute syntax string incorrect for Oracle Names syntax string
ORA-39113: Unable to determine database version
ORA-27092: size of file exceeds file size limit of the process
ORA-14006: invalid partition name
ORA-31072: Too many child nodes in XMLType fragment for updateXML
ORA-28529: invalid or missing parameter in Net8 service name definition
ORA-01529: error closing file 'string'
RMAN-08030: allocated channel: string
ORA-06600: LU6.2 Driver: SNA software is not loaded
RMAN-05511: Datafile string skipped by request
Oracle Errors 
