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

ORA-02398: exceeded procedure space usage

1 Answers  


O2U-00200: Internal error in OTT facility O2U

1 Answers  


RMAN-10039: error encountered while polling for RPC completion on channel string

1 Answers  


ORA-29276: transfer timeout

1 Answers  


ORA-02455: The number of cluster key column must be 1

1 Answers  






ORA-06513: PL/SQL: index for PL/SQL table out of range for host language array

1 Answers  


ORA-00478: SMON process terminated due to error string

1 Answers  


ORA-12546: TNS:permission denied

1 Answers  


RMAN-20202: tablespace not found in the recovery catalog

1 Answers  


DRG-10520: failed to drop index: string

1 Answers  


PROT-00007: Failed to open the specified import file

1 Answers  


NZE-29039: There are no matching cipher suites.

1 Answers  


Categories