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-36184: (XSAGGR10) You do not have sufficient permissions for the variable workspace object.

1 Answers  


RMAN-07517: Reason: The file header is corrupted

2 Answers  


IMG-00524: mismatched quotes

1 Answers  


ORA-12852: PARALLEL_MIN_SERVERS must be less than PROCESSES, string

1 Answers  


PCC-01200: You are not authorized to run Pro*C

1 Answers  






ORA-30016: undo tablespace 'string' is already in use by this instance

1 Answers  


ORA-17610: file 'string' does not exist and no size specified

1 Answers  


SQL*Loader-00486: sql-strings may not be specified for collection field string

1 Answers  


PLS-00143: duplicate external LANGUAGE specification in subprogram expression

1 Answers  


PCC-00008: Invalid WHENEVER action at column number in line number of file string

1 Answers  


DRG-50601: fatal error

1 Answers  


DGM-17002: Primary database can not be removed.

1 Answers  


Categories