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-06808: TLI Driver: could not link IPX and ethernet streams

1 Answers  


ORA-06526: Unable to load PL/SQL library

1 Answers  


RMAN-08507: input datafilecopy recid=string stamp=string filename=string

1 Answers  


TNS-01049: %s (string) has string service handler(s)

1 Answers  


ORA-01224: group number in header string does not match GROUP string

1 Answers  






NNO-00067: server reload check countdown aborted

1 Answers  


NCR-03016: NCRO: Message has bad address

1 Answers  


ORA-26530: unable to build materialized view refresh control list

1 Answers  


ORA-22979: cannot INSERT object view REF or user-defined REF

1 Answers  


ORA-06563: top level procedure/function specified, cannot have subparts

1 Answers  


NNL-00537: set|show server [<server_name>] : set|show the currently managed server

1 Answers  


ORA-00253: character limit string exceeded by archive destination string string

1 Answers  


Categories