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

NID-00602: Could not allocate number bytes for "string"

1 Answers

ORA-16758: The specified apply instance is not running.

1 Answers

RMAN-08126: keep attributes for the proxy copy are changed

1 Answers

ORA-38446: Error with embedded ADT "string" in the attribute set.

1 Answers

NNL-00891: Corrupted messages received: number

1 Answers

RMAN-06548: connected to auxiliary database: string (DBID=string)

1 Answers

PCC-02440: This attribute is valid for either internal or external LOBs

1 Answers

LSX-00152: only "minOccurs", "maxOccurs", or "id" is allowed

1 Answers

QSM-02005: named view in FROM list

1 Answers

PLS-00329: schema-level type has illegal reference to string

1 Answers

ORA-34896: (PPMONTHS00) At least 12 month names must be given. Only number were provided.

1 Answers

ORA-12433: create trigger failed, policy not applied

1 Answers

For more Oracle Errors Interview Questions Click Here