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-28611: bitmap index is corrupted - see trace file for diagnostics

1 Answers  


ORA-12440: insufficient authorization for the SYSDBA package

1 Answers  


ORA-26535: %ud byte row cache insufficient for table with rowsize=number

1 Answers  


TNS-12154: TNS:could not resolve the connect identifier specified

1 Answers  


ORA-31654: unable to convert file or volume size as specified to a number

1 Answers  






ORA-19203: Error occurred in DBMS_XMLGEN processingstring

1 Answers  


TNS-04143: Unable to write the new CMAN.ORA file.

1 Answers  


QSM-02088: mv omits at least one grouping key from the select list

1 Answers  


ORA-33265: (DBERRBSZ) Analytic workspace string cannot be opened. Tablespace blocksize number does not match database cache size number.

1 Answers  


ORA-29848: error occurred in the execution of ODCIINDEXMERGEPARTITION routine

1 Answers  


ORA-06031: NETDNT: connect failed, unrecognized object name

1 Answers  


ORA-12044: invalid CREATE MATERIALIZED VIEW LOG option

1 Answers  


Categories