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

PLS-00320: the declaration of the type of this expression is incomplete or malformed

1 Answers  


ORA-24387: Invalid attach driver

2 Answers  


PLS-00722: supertypes's AUTHID is different than subtype's AUTHID

1 Answers  


ORA-26686: cannot capture from specified SCN

1 Answers  


TNS-01157: Can only listen on number addresses - ignoring string

1 Answers  






ORA-16635: NetSlave connection was broken in the middle of a transmission session.

1 Answers  


ORA-07222: slspool: line printer spooler command exited with an error.

1 Answers  


TNS-01045: %s(Not Registered) has string service handler(s)

1 Answers  


QSM-02119: internal error while analyzing required supporting aggregates

1 Answers  


ORA-06446: ssvpstevrg: Failed with unexpected error number.

1 Answers  


RMAN-06606: RMAN configuration parameters are successfully reset to default value

1 Answers  


ORA-32035: unreferenced query name defined in WITH clause

1 Answers  


Categories