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..

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

RMAN-06004: ORACLE error from recovery catalog database: string

1 Answers  


NID-00416: Change of database name failed.

1 Answers  


ORA-38488: attribute set already assigned to the column storing expressions

1 Answers  


NZE-29189: No entry found in OID

1 Answers  


ORA-14158: too many subpartition descriptions

1 Answers  






ORA-23609: unable to find directory object for directory string

1 Answers  


ORA-19511: Error received from media manager layer, error text: string

1 Answers  


PLS-01473: Use <> instead of != or ~=

1 Answers  


LPX-00123: duplicate ID "~S"

1 Answers  


ORA-12696: Double Encryption Turned On, login disallowed

1 Answers  


ORA-07287: sksagdi: unsupported device for log archiving.

1 Answers  


ORA-33078: (XSAGDNGL39) In AGGMAP workspace object, the hierarchy dimension QDR workspace object must refer to a dimension.

1 Answers  


Categories