ORA-02307: cannot alter with REPLACE option a type that is
not valid



ORA-02307: cannot alter with REPLACE option a type that is not valid..

Answer / guest

Cause: An attempt was made to ALTER with REPLACE option a
type that is not valid.

Action: Use the CREATE OR REPLACE TYPE command to modify the
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-38303: invalid option for PURGE TABLESPACE

1 Answers  


ORA-25405: transaction status unknown

1 Answers  


QSM-01037: Query Rewrite failed to allocate the necessary query join graph

1 Answers  


ORA-00911: invalid character

1 Answers  


NNL-00235: Auto-refresh failure-retry expiration period is now string

1 Answers  


NID-00600: Internal Error - [number] [number] [number] [number]

1 Answers  


PLS-00506: User Defined Constrained Subtypes are disallowed

1 Answers  


ORA-07628: smsfre: sga not mapped

1 Answers  


ORA-27206: requested file not found in media management catalog

1 Answers  


ORA-29959: error in the execution of the string routine for one or more of the index partitions

1 Answers  


TNS-00044: INTCTL: You must have an INTCHG.ORA file to contact the Connection Manager

1 Answers  


RMAN-05007: no channel allocated

1 Answers  


Categories