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-04001: heap initialization failure

1 Answers  


ORA-09209: sftget: error reading from file

1 Answers  


SQL*Loader-00200: FORMAT clause should not be present - flat data files only

1 Answers  


SQL*Loader-00402: Unable to determine length of column string from specification

1 Answers  


DRG-13309: operation not supported by USER_LEXER

1 Answers  


ORA-19659: incremental restore would advance file string past resetlogs

1 Answers  


ORA-32695: HTI: Not enough memory

1 Answers  


ORA-01512: error renaming log file string - new file string not found

1 Answers  


ORA-31521: CDC subscription string already subscribes to publication ID string column string

1 Answers  


PLS-00702: second argument to PRAGMA EXCEPTION_INIT must be a numeric literal

1 Answers  


NNO-00711: cache dump countdown aborted

1 Answers  


NZE-29026: Decryption failure

1 Answers  


Categories