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 |
LSX-00273: invalid character "~c" in base64-encoded binary
PCC-02386: Use of the AT clause is not permitted here
ORA-15124: ASM file name 'string' contains an invalid alias name
PROC-00010: Cannot delete the cluster registry key as subkeys exist.
ORA-16084: an apply engine is already running
EXP-00020: failed to allocate memory of size number
ORA-29801: missing RETURN keyword
ORA-14273: lower-bound partition must be specified first
ORA-40002: wordsize must be string or greater
ORA-27050: function called with invalid FIB/IOV structure
ORA-36778: (XSPGTRLOW) The amount of available temporary storage is still low. Free some temporary storage immediately. You can do so, for example, by UPDATING or DETACHING an analytic workspace.
ORA-09353: Windows 32-bit Two-Task driver unable to open event semaphore