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

AMD-00133: measure #string: analytic workspace measure name not specified

1 Answers  


PCC-00115: Array required here

1 Answers  


ORA-24012: cannot drop QUEUE_TABLE, some queues in string have not been dropped

1 Answers  


ORA-25403: could not reconnect

1 Answers  


NNO-00055: invalid domain minimum TTL "string"

1 Answers  


ORA-29841: invalid option for ALTER INDEXTYPE

1 Answers  


ORA-25469: data not specified for alias: string column name: string

1 Answers  


ORA-12646: Invalid value specified for boolean parameter

1 Answers  


DRG-11422: linguistic initialization failed

1 Answers  


TNS-12660: Encryption or crypto-checksumming parameters incompatible

1 Answers  


IMP-00017: following statement failed with ORACLE error number:

1 Answers  


NNC-00418: name "string" cannot be modified because it has children

1 Answers  


Categories