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-07582: spstp: ORA_SID has illegal value

1 Answers  


ORA-02465: Inappropriate use of the HASH IS option

1 Answers  


ORA-29348: You must specify the datafiles to be plugged in

1 Answers  


IMG-00843: internal image structure allocation failed

1 Answers  


SQL*Loader-00506: formatting error reading SDF or LOBFILE string for column string in table string

1 Answers  






ORA-27501: IPC error creating a port

1 Answers  


ORA-09759: osnsbt: bad message received.

1 Answers  


TNS-12600: TNS: string open failed

1 Answers  


NID-00407: Reversion of database ID failed.

1 Answers  


ORA-36394: (XSMXCLEA04) When using CLEAR on the AGGMAP workspace object, CACHE is the only valid directive.

1 Answers  


TNS-12665: NLS string open failed

1 Answers  


ORA-32696: HTI: No free slot

1 Answers  


Categories