ORA-22870: ALTER TYPE with REPLACE option a non-object type



ORA-22870: ALTER TYPE with REPLACE option a non-object type..

Answer / guest

Cause: attempt to perform ALTER TYPE with REPLACE option a
non-object type

Action: drop the non-object type first, then re-create it as
an object type

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

LPX-00284: namespace prefix to NULL URI is not allowed

1 Answers  


ORA-24007: invalid value string, MAX_RETRIES should be non-negative integer

1 Answers  


QSM-02020: container column not in SELECT list with NOT NULL constraint

1 Answers  


ORA-12079: materialized view options require COMPATIBLE parameter to be string or greater

1 Answers  


ORA-02434: cannot enable unique(string) - unique key not defined for table

1 Answers  






ORA-00297: must specify RECOVER DATAFILE LIST before RECOVER DATAFILE START

1 Answers  


ORA-19815: WARNING: string of string bytes is string used, and has string remaining bytes available.

1 Answers  


DRG-10835: WITHIN operator not supported for theme index

1 Answers  


ORA-12152: TNS:unable to send break message

1 Answers  


ORA-37107: (XSVPART07) Attempt to write to non-existent partition of workspace object.

1 Answers  


PLS-00373: EXIT label 'string' must label a LOOP statement

1 Answers  


ORA-12550: TNS:syntax error

1 Answers  


Categories