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
5380 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

EXP-00013: respond with either 'Y', 'N', RETURN or '.' to quit

1 Answers

ORA-09969: scurls: unable to close lock file

1 Answers

LSX-00344: namespace values "~1S" and "~2S" differ

1 Answers

ORA-19623: file string is open

1 Answers

ORA-32007: internal

1 Answers

ORA-07665: ssrexhd: recursive exception encountered string string string string string string

1 Answers

NID-00141: No database name specified, previous attempt used string

1 Answers

ORA-07264: spwat: semop error, unable to decrement semaphore.

1 Answers

ORA-14037: partition bound of partition "string" is too high

1 Answers

ORA-15073: diskgroup string is mounted by another ASM instance

1 Answers

ORA-01497: illegal option for ANALYZE CLUSTER

1 Answers

PCC-01002: Invalid character "character" in indicator area at line number in file string

1 Answers

For more Oracle Errors Interview Questions Click Here