Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-16082: logical standby is not initialized correctly

1 Answers  


IMP-00046: using FILESIZE value from export file of string

1 Answers  


ORA-14315: cannot merge a partition with itself

1 Answers  


ORA-31503: invalid date supplied for begin_date or end_date

1 Answers  


TNS-00544: unsupported operation

1 Answers  






NCR-04014: NCRR: Invalid instance name

1 Answers  


ORA-30936: Maximum number (string) of 'string' XML node elements exceeded

1 Answers  


ORA-16170: Terminal recovery may have left the database in an inconsistent state

1 Answers  


PLS-00257: illegal use of EXTERNAL clause in a TYPE or PACKAGE specification

1 Answers  


PLS-00240: Invalid type specification for RETURN indicator, length, tdo, duration

1 Answers  


SQL*Loader-00263: PIECED column string must be last specified column in table string

1 Answers  


SQL*Loader-00507: unexpected EOF reading SDF or LOBFILE string for column string in table string

1 Answers  






Categories