ORA-22312: must specify either CASCADE or INVALIDATE option



ORA-22312: must specify either CASCADE or INVALIDATE option..

Answer / guest

Cause: An attempt was made to alter a type which has a
dependent type or table without specifying the CASCADE or
INVALIDATE option.

Action: Resubmit the statement with either the CASCADE or
INVALIDATE option. Specify CASCADE if you want to cascade
the type change to dependent types and tables; otherwise,
specify INVALIDATE to invalidate all dependents.

Please add more information about this Error

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

RMAN-12020: error on step filtered for normal output string

1 Answers  


ORA-02421: missing or invalid schema authorization identifier

1 Answers  


ORA-02795: Request list is empty

1 Answers  


ORA-02818: Less than the number of blocks requested was read in

1 Answers  


RMAN-10030: RPC call appears to have failed to start on channel string

1 Answers  






ORA-12729: invalid character class in regular expression

1 Answers  


TNS-01053: Connecting to string

1 Answers  


ORA-31663: metadata remap name can not be defaulted

1 Answers  


ORA-02363: error reading from file: string

1 Answers  


PLS-00661: RETURN statement in a CONSTRUCTOR cannot include an expression

1 Answers  


NZE-28784: file name translation failure

1 Answers  


IMG-00556: incorrect number of gamma values

1 Answers  


Categories