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

LFI-00129: Invalid option string were specified on an input only file.

1 Answers  


NZE-29233: the key object could not be encoded

1 Answers  


ORA-22321: method does not return any result

1 Answers  


ORA-02060: select for update specified a join of distributed tables

1 Answers  


ORA-40222: data mining model export failed, job name=string, error=string

1 Answers  






LFI-00109: Unable to open file [string][string]. string.

1 Answers  


ORA-16626: failed to enable specified object

0 Answers  


ORA-06751: TLI Driver: bound addresses unequal

1 Answers  


ORA-28156: Proxy user 'string' not authorized to set role 'string' for client 'string'

1 Answers  


DRG-12308: use ctx_ddl.create_index_set to create index sets

1 Answers  


PCC-00071: Unable to open message file.

1 Answers  


ORA-09942: Write of ORACLE password file header failed.

1 Answers  


Categories