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

ORA-32405: cannot alter tablespace for existing materialized view log

1 Answers  


ORA-19200: Invalid column specification

1 Answers  


ORA-30382: DROP MATERIALIZED VIEW string.string operation is not complete

1 Answers  


ORA-01649: operation not allowed with a backup controlfile

1 Answers  


ORA-08118: Deferred FK constraints cannot be enforced, index too big (string)

1 Answers  






ORA-31623: a job is not attached to this session via the specified handle

1 Answers  


ORA-28662: IOT index and overflow segments must share the same LOGGING attribute

1 Answers  


ORA-22062: invalid input string [string]

1 Answers  


ORA-19028: Invalid ADT parameter passed to toObject() function

1 Answers  


ORA-25350: maximum number of concurrent transaction branches exceeded

1 Answers  


ORA-36639: (XSDUNION18) UNIQUE cannot be applied to this concat dimension because leaves workspace object and workspace object share the value number.

1 Answers  


RMAN-08133: channel string: the autobackup does not contain a standby controlfile.

1 Answers  


Categories