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

LCD-00114: illegal boolean response [string]

1 Answers  


ORA-02440: Create as select with referential constraints not allowed

1 Answers  


ORA-09856: smpalo: vm_allocate error while allocating pga.

1 Answers  


ORA-19906: recovery target incarnation changed during recovery

1 Answers  


ORA-08451: invalid specification of DB in picture mask

1 Answers  






ORA-01170: file not found 'string'

1 Answers  


ORA-01164: MAXLOGFILES may not exceed string

1 Answers  


DRG-50932: parser preference initialization failed

1 Answers  


RMAN-20501: redo logs from parent database incarnation cannot be applied

1 Answers  


ORA-19676: one or more files failed during proxy backup or restore

1 Answers  


QSM-02034: no joins are present in the HAVING clause

1 Answers  


ORA-30332: container table already in use by other summary

1 Answers  


Categories