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

ORA-24037: schema string in QUEUE_NAME is not same as schema string in QUEUE_TABLE

1 Answers  


ORA-32822: subscriber string is marked for removal

1 Answers  


RMAN-08157: script string written to file string

1 Answers  


ORA-16753: Resource guard could not open standby database

1 Answers  


ORA-12569: TNS:packet checksum failure

1 Answers  






ORA-16107: all log data from primary has been processed

1 Answers  


ORA-00302: limit of string logs exceeded

1 Answers  


PLS-00145: duplicate external WITH CONTEXT specification in subprogram expression

1 Answers  


ORA-30082: datetime/interval column to be modified must be empty to decrease fractional second or leading field precision

1 Answers  


ORA-25534: _MEAN_TIME_TO_CLUSTER_AVAILABILITY is specified

1 Answers  


SQL*Loader-00919: Error during upi fetch: [number]

1 Answers  


ORA-24412: Cannot reinitialize non-existent pool

1 Answers  


Categories