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
5384 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-04077: WARNING: No password set for the Oracle Connection Manager instance.

1 Answers

ORA-13001: dimensions mismatch error

1 Answers

EXP-00085: The previous problem occurred when calling string.string.string for object number

1 Answers

ORA-13851: Tracing for client identifier string is already enabled

1 Answers

LPX-00012: Unicode data alignment error

1 Answers

ORA-07238: slemcl: close error.

1 Answers

ORA-28276: Invalid ORACLE password attribute.

1 Answers

ORA-01882: timezone region string not found

1 Answers

ORA-14621: cannot add subpartition when DEFAULT subpartition exists

1 Answers

ORA-22632: AnyDataSet parameter is not valid for the current operation

1 Answers

KUP-04060: field string referenced by lobfile column string not found

1 Answers

RMAN-06250: Report of files that need backup due to unrecoverable operations

1 Answers

For more Oracle Errors Interview Questions Click Here