Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


ORA-22856: cannot add columns to object tables

Answers were Sorted based on User's Feedback



ORA-22856: cannot add columns to object tables..

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

ORA-22856: cannot add columns to object tables..

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

Post New Answer

More Oracle Errors Interview Questions

ORA-02199: missing DATAFILE/TEMPFILE clause

1 Answers  


ORA-00096: invalid value string for parameter string, must be from among string

1 Answers  


RMAN-08096: channel string: starting validation of datafile backupset

1 Answers  


ORA-04043: object string does not exist

1 Answers  


EXP-00073: dump file size too small

1 Answers  






PROC-00002: Cannot perform cluster registry operation at the current init level.

1 Answers  


ORA-12989: invalid value for checkpoint interval

1 Answers  


ORA-02777: Stat failed on log directory

1 Answers  


ORA-10660: Segment is a shared lob segment

1 Answers  


TNS-01178: Trace Level is 0. Trace file/directory unchanged

1 Answers  


ORA-13390: error in spatial analysis and mining function: [string]

1 Answers  


ORA-01900: LOGFILE keyword expected

1 Answers  






Categories