Sign Up Login


  1. Categories >> ERRORS >> Database Errors >> Oracle Errors
  2. Suggest New Category

ORA-02311: cannot alter with COMPILE option a valid type
with type or table dependents

Question Posted / guest


ORA-02311: cannot alter with COMPILE option a valid type with type or table dependents..

Answer / guest

Cause: An attempt was made to ALTER with COMPILE option a
type that is valid and has type or table dependents.

Action: No need to perform this operation.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

PCC-02112: OBJECTS option ignored. OBJECTS=YES is not allowed for DBMS=V6 or V7.

1 Answers  

ORA-14507: partition corrupt. all rows do not fall within partition bounds

1 Answers  

SQL-02148: ANSI Dynamic count value out of range

1 Answers  

NCR-03017: NCRO: Transport type RSLV not supported

1 Answers  

ORA-36679: (XSDPART17) workspace object contains a leaf (workspace object) that is not part of the partition dimension workspace object.

1 Answers  

TNS-01306: nt secondary err code: number

1 Answers  

ORA-31418: source schema string does not exist

1 Answers  

LFI-00101: Write failed, file cannot be written to.

1 Answers  

ORA-16209: Logical standby dictionary build failed to complete.

1 Answers  

ORA-06143: NETTCP: maximum connections exceeded

1 Answers  

NCR-01010: NCRS: Invalid network address length.

1 Answers  

LSX-00156: type is final and no derivations are allowed

1 Answers  

For more Oracle Errors Interview Questions Click Here
Categories