Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-22856: cannot add columns to object tables
- 2 Answers
- 6002 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-01085: materialized view, string, has a lossy join between tables, string
ORA-30484: missing window specification for this function
ORA-04085: cannot change the value of an OLD reference variable
NNF-04003: Entry in inputfile is too long
PCC-02043: CMD-LINE: Option syntax is incorrect
ORA-19611: backup piece out of order. Expected string but found string
LSX-00294: field "~S" produced multiple hits
DRG-50100: CORE LSF error: string
ORA-16727: resource guard cannot close database
ORA-16639: specified instance inactive or currently unavailable
ORA-30334: illegal dimension level name
TNS-12222: TNS:no support is available for the protocol indicated
Oracle Errors 
