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



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

ORA-09354: Windows 32-bit Two-Task driver: ORACLE task unexpectedly died

1 Answers  


ORA-30201: Unable to load NLS data object

1 Answers  


ORA-12425: cannot apply policies or set authorizations for system schemas

1 Answers  


ORA-06761: TLI Driver: error sending orderly release

1 Answers  


NNF-00002: Invalid value passed to function call

1 Answers  


RMAN-08180: channel string: restore complete, elapsed time: string

1 Answers  


ORA-24960: the attribute string is greater than the maximum allowable length of number

1 Answers  


PCC-00124: COMMON_NAME option is specified too late

1 Answers  


ORA-38431: could not evaluate subexpression "string" for rowid "string"

1 Answers  


TNS-04044: Specified gateways do not exist.

1 Answers  


ORA-23317: a communication failure has occurred

1 Answers  


RMAN-08038: channel string: starting piece string at string

1 Answers  


Categories