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

ORA-00105: too many dispatcher configurations

1 Answers  


ORA-13438: GeoRaster metadata pyramid type error

1 Answers  


PLS-01425: Connect-by clause

1 Answers  


ORA-31111: table string cannot be hierarchically enabled

1 Answers  


ORA-01660: tablespace 'string' is already permanent

1 Answers  


ORA-24771: cannot detach, prepare or forget a local transaction

1 Answers  


ORA-29302: database is not open clone

1 Answers  


ORA-07564: sldext: wildcard in filename or extension

1 Answers  


ORA-27143: OS system call failure

1 Answers  


DRG-50700: unknown command (args=queue, command)

1 Answers  


ORA-06117: NETTCP: unable to create ORASRV: quota exceeded

1 Answers  


NCR-03022: NCRO: Cannot send the break

1 Answers  


Categories