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

PLS-00901: the data type of column 'string' of table 'string' is not supported

1 Answers  


LPX-00606: Missing attribute '~1s' in element '~2S'.

1 Answers  


ORA-06518: PL/SQL: Probe version string incompatible with version string

1 Answers  


ORA-02065: illegal option for ALTER SYSTEM

1 Answers  


NNO-00112: line string: ignored duplicate data of type "string"

1 Answers  






NNL-00262: Request forwarding is currently disabled

1 Answers  


ORA-36815: (XSTBLFUNC08) The OLAP_TABLE has attempted to use an AW single row function with the aw_attach parameter set to DURATION QUERY.

1 Answers  


ORA-13149: failed to generate next sequence number for spatial table string

1 Answers  


ORA-12724: regular expression corrupt

1 Answers  


ORA-12983: cannot drop all columns in a table

1 Answers  


ORA-39068: invalid master table data in row with PROCESS_ORDER=string

1 Answers  


IMG-00601: out of memory while copying image

1 Answers  


Categories