Showing posts with label ORA-22871: ALTER TYPE with REPLACE is not allowed for pure incomplete types. Show all posts
Showing posts with label ORA-22871: ALTER TYPE with REPLACE is not allowed for pure incomplete types. Show all posts

Wednesday, 11 April 2012

ORA-22871: ALTER TYPE with REPLACE is not allowed for pure incomplete types

ORA-22871: ALTER TYPE with REPLACE is not allowed for pure incomplete types

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

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