ORA-22312: must specify either CASCADE or INVALIDATE option - Oracle Database 12c Error Messages

Channel:

java frm

Subscribers:

5,740

Published on March 15, 2023 8:16:03 PM ● Video Link: https://www.youtube.com/watch?v=1sol3h1MAPo

Duration: 1:51

4 views

0

In this video we are going to see how to fix below Oracle Database 12c Error Message.

ORA-22312: must specify either CASCADE or INVALIDATE option.
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.

#12c #oracledatabase12c #oracledatabase #oracledba #sql #oraclesql #oraerrors #oracleerrorcodes #dba #database