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

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

Question Posted / guest

1 Answers
5298 Views
I also Faced
E-Mail Answers

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

TNS-01046: Saved string configuration parameters.

1 Answers

ORA-22329: cannot alter a non-object type

1 Answers

RMAN-06432: recovery catalog dropped

1 Answers

IMG-00824: fail queue pop failed

1 Answers

ORA-01669: standby database controlfile not consistent

1 Answers

PLS-00156: Null constraints not supported for object attributes.

1 Answers

ORA-00207: controlfiles are not for the same database

1 Answers

ORA-23347: datatype string for column string table string not supported

1 Answers

ORA-01149: cannot shutdown - file string has online backup set

2 Answers

ORA-29877: failed in the execution of the ODCIINDEXUPDATE routine

2 Answers HCL,

ORA-30362: dimension column cannot be a sequence

1 Answers

TNS-00316: Ran out of data buffers in the pump

1 Answers

For more Oracle Errors Interview Questions Click Here