Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-22856: cannot add columns to object tables
- 2 Answers
- 5886 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-29931: specified association does not exist
ORA-02822: Invalid block offset
TNS-00026: INTCTL: TNS_ADMIN directory set, and is being used
ORA-02494: invalid or missing maximum file size in MAXSIZE clause
RMAN-08044: channel string: finished piece string at string
ORA-13711: Some snapshots in the range [string, string] are missing key statistics.
ORA-27477: "string.string" already exists
ORA-13340: a point geometry has more than one coordinate
ORA-13292: incorrect ARC_TOLERANCE specification
KUP-04085: duplicate directory object string and file string specified for unload
DRG-12900: Operation:string for index: string has already been started
NNL-00016: cannot start server, error getting program directory's name
Oracle Errors 
