ORA-22857: cannot modify columns of object tables



ORA-22857: cannot modify columns of object tables..

Answer / guest

Cause: An attempt was made to alter the object table by
modifing existing columns. An object table cannot be altered
to modify existing columns since it is based on an object
type. The table definition must be in sync with the
corresponding type.

Action: Create a new type with the desired attribute types
and use it 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 0 No

Post New Answer

More Oracle Errors Interview Questions

DRG-50601: fatal error

1 Answers  


DRG-10758: index owner does not have the privilege to use this preference

1 Answers  


ORA-39502: failed to notify CRS of a Startup/Shutdown event [number] (ignored)

1 Answers  


ORA-32773: operation not supported for smallfile tablespace string

1 Answers  


O2F-00324: Unable to convert from the database character set to the compiler character set

1 Answers  


NNO-00624: setting auto-refresh expiration period to number seconds

1 Answers  


RMAN-06545: "string" is an invalid response - please re-enter.

1 Answers  


ORA-10618: Operation not allowed on this segment

1 Answers  


ORA-13157: Oracle error ORAstring encountered while string

1 Answers  


ORA-30102: 'string' is not in the legal range for 'string'

1 Answers  


ORA-12223: TNS:internal limit restriction exceeded

1 Answers  


ORA-02738: osnpwrtbrkmsg: incorrect number of bytes written

1 Answers  


Categories