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

NNC-00400: memory exhausted

1 Answers  


ORA-25155: column used in NATURAL join cannot have qualifier

2 Answers  


ORA-07754: slemcf: fwrite failure

1 Answers  


NNO-00635: warning: ignoring duplicate forwarder "string"

1 Answers  


ORA-06749: TLI Driver: option not allowed across network

1 Answers  






ORA-09948: Process information label retrieval failed.

1 Answers  


ORA-01919: role 'string' does not exist

1 Answers  


ORA-16165: LGWR failed to hear from network server

1 Answers  


ORA-15034: disk 'string' does not require the FORCE option

1 Answers  


ORA-10566: Test recovery has used all the memory it can use

1 Answers  


ORA-02428: could not add foreign key reference

1 Answers  


ORA-06722: TLI Driver: connection setup failure

1 Answers  


Categories