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
5283 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-00085: * reread - ask the process name to reread parameter files

1 Answers

ORA-01928: GRANT option not granted for all privileges

1 Answers

ORA-12075: invalid object or field

1 Answers

ORA-01222: MAXINSTANCES of string requires MAXLOGFILES be at least string, not string

1 Answers

SQL*Loader-00555: unrecognized processing option

1 Answers

ORA-16814: incorrect log transport setting for standby's AlternateLocation

1 Answers

ORA-07634: smsdbp: $CRETVA failure

1 Answers

ORA-30932: Reference node 'string' not contained in specified parent node 'string'

1 Answers

ORA-28650: Primary index on an IOT cannot be rebuilt

1 Answers

ORA-13350: two or more rings of a complex polygon touch

1 Answers

ORA-09881: sstasfre/sstasdel: shmdt error, unable to detach tas read page

1 Answers

ORA-01271: Unable to create new file name for file string

1 Answers

For more Oracle Errors Interview Questions Click Here