ORA-22870: ALTER TYPE with REPLACE option a non-object type



ORA-22870: ALTER TYPE with REPLACE option a non-object type..

Answer / guest

Cause: attempt to perform ALTER TYPE with REPLACE option a
non-object type

Action: drop the non-object type first, then re-create it as
an object type

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-14626: values being added already exist in DEFAULT subpartition

1 Answers  


UDE-00017: Data Pump job is already executing.

1 Answers  


ORA-19024: Cursor expression must be named

1 Answers  


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

1 Answers  


ORA-02165: invalid option for CREATE DATABASE

1 Answers  






LFI-00100: Unable to perform operation, file not opened in string.

1 Answers  


ORA-34481: (MXMAINT07) You cannot string values of PARTITION TEMPLATE workspace object.

1 Answers  


LCD-00204: left parenth and no parameter specified [string]

1 Answers  


ORA-33070: (XSAGDNGL34) In AGGMAP workspace object, all QDRs of dimension workspace object must map to the same dimension position.

1 Answers  


ORA-37114: OLAP API bootstrap error: (string)

1 Answers  


PCB-00106: Unable to open INCLUDE file "string"

1 Answers  


PCC-02135: CMD-LINE: User asked for help

1 Answers  


Categories