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

PCC-02206: Host variables are not permitted within a DDL statement

1 Answers  


ORA-37121: AW Spreadsheet invalidated

1 Answers  


ORA-00263: there are no logs that need archiving for thread string

1 Answers  


DRG-12006: Plase enter account:

1 Answers  


ORA-02849: Read failed because of an error

1 Answers  






ORA-28546: connection initialization failed, probable Net8 admin error

1 Answers  


LSX-00014: empty instance document

1 Answers  


ORA-00085: current call does not exist

1 Answers  


ORA-02063: preceding stringstring from stringstring

1 Answers  


ORA-31500: change source string is not a ManualLog change source

1 Answers  


ORA-16803: Unable to query a database table or fixed view.

2 Answers  


RMAN-00554: initialization of internal recovery manager package failed

1 Answers  


Categories