Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-22856: cannot add columns to object tables
- 2 Answers
- 6094 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-16613: initialization in progress for site
TNS-01305: nt main err code: number
LPX-00227: entity "~S" is not a parsed entity
ORA-01235: END BACKUP failed for string file(s) and succeeded for string
ORA-38738: Flashback log file is not current copy.
ORA-31045: Cannot store more than string extras outside the root XML node
ORA-30343: level name is not unique within this dimension
PLS-00664: Both ORDER BY and CLUSTER BY can not be specified for the same table function
ORA-07704: error in archive text: need ':' after device name
PLS-00148: Only 1 pragma of this type is allowed per subprogram
ORA-08102: index key not found, obj# string, file string, block string (string)
ORA-32836: database user string must be granted role string
Oracle Errors 
