Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-22856: cannot add columns to object tables
- 2 Answers
- 5980 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-31433: subscriber view does not exist
PLS-01501: Options in CREATE TABLE statement is non-ANSI.
NZE-28852: Bad password
PCC-02395: Using arrays of structs requires that the struct be named
ORA-08275: Environment variable unset
RMAN-06095: a backup controlfile must be restored to recover datafile string
QSM-01033: query rewritten with materialized view, string
ORA-25326: Array string operation failed for message at index string
ORA-00607: Internal error occurred while making a change to a data block
RMAN-06471: no configuration found to allocate channels for string
ORA-29324: SET COMPATIBILITY release string format is wrong
TNS-12513: TNS:service handler found but it has registered for a different protocol
Oracle Errors 
