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

ORA-00827: could not shrink sga_target to specified value

1 Answers

NNL-00010: error getting address for server "string"

1 Answers

ORA-13434: GeoRaster metadata cellRepresentation error

1 Answers

PLS-01415: Use of aggregate value here

1 Answers

ORA-09261: spdcr: error creating detached (background) process

1 Answers

ORA-32825: Messaging Gateway agent has not been started

1 Answers

ORA-19655: cannot switch to incarnation with different resetlogs data

1 Answers

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

1 Answers

ORA-32158: Invalid type passed

1 Answers

NID-00604: No control files found in database

1 Answers

SQL*Loader-00104: Invalid bad file name on command line

1 Answers

NZE-28819: No distinguished name provided.

1 Answers

For more Oracle Errors Interview Questions Click Here