ORA-22856: cannot add columns to object tables
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 |
PCC-02206: Host variables are not permitted within a DDL statement
ORA-37121: AW Spreadsheet invalidated
ORA-00263: there are no logs that need archiving for thread string
DRG-12006: Plase enter account:
ORA-02849: Read failed because of an error
ORA-28546: connection initialization failed, probable Net8 admin error
LSX-00014: empty instance document
ORA-00085: current call does not exist
ORA-02063: preceding stringstring from stringstring
ORA-31500: change source string is not a ManualLog change source
ORA-16803: Unable to query a database table or fixed view.
RMAN-00554: initialization of internal recovery manager package failed