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-32762: Turn on Temp LOB Ref Count Tracing

1 Answers  


RMAN-06164: WARNING: no channel of required type allocated to recover datafile number

1 Answers  


SQL*Loader-00131: Invalid multithreading option

1 Answers  


TNS-00279: Navigator: Failed to Start Tracing

1 Answers  


RMAN-06073: file header is corrupt for datafile string

1 Answers  






RMAN-06474: maintenance channels are not allocated

1 Answers  


CLSR-00004: Error encountered at string, category=number, operation=string, OS error=number

1 Answers  


VID-00705: unsupported input format

1 Answers  


ORA-01415: too many distinct aggregate functions

1 Answers  


PCC-00080: TYPE identifier already TYPEd

1 Answers  


ORA-36188: (XSAGGR16) AGGREGATE read a value less than 1 out of COUNTVAR variable workspace object. Either the values of the COUNTVAR variable are stored improperly, or there is problem in AGGREGATE. If no one has modified the values in this COUNTVAR, contact Oracle customer support.

1 Answers  


PLS-00662: Non-external object types containing external mapped attributes are not allowed

1 Answers  


Categories