The following is the ORA-22870 error message, you can learn the cause and solution of the Oracle database error.


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

Cause: An attempt was made to perform ALTER TYPE with REPLACE option a non-object type.

Solution: Drop the non-object type first, then re-create it as an object type.

Case:

Please wait for the update…