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 |
RMAN-06496: must use the TO clause when the database is mounted or open
ORA-02494: invalid or missing maximum file size in MAXSIZE clause
NNO-00316: statistic counter reset disabled
DRG-50919: NEAR operand not a phrase, equivalence or another NEAR expression
NID-00406: Reversion of database name failed.
ORA-25179: invalid PCTTHRESHOLD storage option value
LFI-01501: tmpnam() fails to generate temporary file name.
SQL*Loader-00559: error closing file
NNL-00353: Not allowed
NNL-00506: reset_stats [<server_list>] : reset Names server statistics
ORA-35756: (VCTODT02) 'number' is not a valid date because number is out of range for a year.
IMG-00841: image data allocation failed