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

DRG-52204: error while registering index

1 Answers  


ORA-15034: disk 'string' does not require the FORCE option

1 Answers  


ORA-25438: invalid variable name: string

1 Answers  


ORA-00231: snapshot controlfile has not been named

1 Answers  


ORA-23453: requested operation is not supported on top flavor

1 Answers  


TNS-00528: Protocol Adapter not loaded

1 Answers  


ORA-29836: failed to validate referenced operators

1 Answers  


PLS-01425: Connect-by clause

1 Answers  


ORA-12723: regular expression too complex

1 Answers  


PLS-00708: Pragma string must be declared in a package specification

1 Answers  


ORA-08108: may not build or rebuild this type of index online

1 Answers  


TNS-01413: "string" established:string refused:string current:string max:string state:string

1 Answers  


Categories