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

PLS-00202: type 'string' must be declared

1 Answers  


ORA-31206: DBMS_LDAP: PL/SQL - Invalid LDAP search scope.

1 Answers  


ORA-24077: cannot create propagation schedule for EXCEPTION queue string.string

1 Answers  


ORA-29863: warning in the execution of ODCIINDEXCREATE routine

1 Answers  


ORA-27125: unable to create shared memory segment

1 Answers  


ORA-01197: thread string only contains one log

1 Answers  


ORA-13457: GeoRaster cell data error

1 Answers  


PLS-00249: Invalid WITH CONTEXT Syntax

1 Answers  


ORA-22371: Table contains data of type string.string, version string, which does not exist

1 Answers  


PCB-00578: Variable "string" must be a table

1 Answers  


ORA-14080: partition cannot be split along the specified high bound

1 Answers  


ORA-10657: Lob column to be shrunk does not exist

1 Answers  


Categories