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

RMAN-12015: configuration for string channel number is ignored

1 Answers  


RMAN-08542: channel string: starting proxy archivelog backup at string

1 Answers  


PLS-00432: implementation restriction: cannot use FORALL and BULK COLLECT INTO together in SELECT statements

1 Answers  


ORA-01620: no public threads are available for mounting

1 Answers  


NID-00125: Database should have no disabled datafiles

1 Answers  


ORA-27036: translation error, unable to expand file name

1 Answers  


ORA-30677: session is already connected to a debugger

1 Answers  


TNS-12599: TNS:cryptographic checksum mismatch

1 Answers  


ORA-26665: STREAMS process string already exists

1 Answers  


ORA-14601: Illegal to specify SUBPARTITIONS or STORE-IN while specifying a subpartition template

1 Answers  


RMAN-06113: changed archive log available

1 Answers  


ORA-26685: cannot apply transactions from multiple sources

1 Answers  


Categories