ORA-22343: Compilation error for type invalidated by ALTER TYPE



ORA-22343: Compilation error for type invalidated by ALTER TYPE..

Answer / guest

Cause: Compilation failed for a type which was invalidated
by ALTER TYPE. We throw this error and rollback the
compilation effort so that the user may be able to fix
whatever is causing the compilation error and try again. It
is important that we do not chnage status here and modify
the dependency information as this will affect the creation
of versions.

Action: Check what is causing teh compilation error and
correct it and try again.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-10922: Temporary tablespace group is empty

1 Answers  


ORA-07700: sksarch: interrupt received

1 Answers  


ORA-00215: must be at least one controlfile

1 Answers  


ORA-27543: Failed to cancel outstanding IPC request

1 Answers  


ORA-16800: Log transport service for some database is incorrectly set to ALTERNATE.

1 Answers  






SQL*Loader-00703: Internal error: argument number

1 Answers  


TNS-12654: Authentication conversion failed

1 Answers  


ORA-37132: (XSCCOMP07) Incremental aggregation over the dense DIMENSION workspace object is not supported when aggregating a VARIABLE dimensioned by a COMPRESSED COMPOSITE.

1 Answers  


ORA-09280: sllfcf: error closing file

1 Answers  


TNS-12213: TNS:incomplete PREFERRED_CMANAGERS binding in TNSNAV.ORA

1 Answers  


ORA-39125: Worker unexpected fatal error in string while calling string [string]

1 Answers  


ORA-12350: database link being dropped is still mounted

1 Answers  


Categories