Oracle Error Codes

All Oracle Database Error Codes

Oracle database error code ORA-22871 – ALTER TYPE with REPLACE is not allowed for pure incomplete types

Oracle Database Error Code ORA-22871 Description :

ALTER TYPE with REPLACE is not allowed for pure incomplete types

Error Cause:

An attempt to perform ALTER TYPE with REPLACE option for a pure incomplete type

How to Solve :

Completely define the original type, before using the ALTER TYPE with REPLACE option.