ORA-02303: cannot drop or replace a type with type or table
dependents



ORA-02303: cannot drop or replace a type with type or table dependents..

Answer / guest

Cause: An attempt was made to drop or replace a type that
has dependents. There could be a substitutable column of a
supertype of the type being dropped.

Action: Drop all type(s) and table(s) depending on the type,
then retry the operation using the VALIDATE option, or use
the FORCE option.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-12047: PCT FAST REFRESH cannot be used for materialized view "string"."string"

1 Answers  


ORA-23304: malformed deferred rpc at arg string of string in call string, in tid string

1 Answers  


TNS-00208: Logging : string

1 Answers  


DRG-13003: preference string cannot be used as a sub lexer

1 Answers  


LSX-00221: "~1S" is too short (minimum length is ~2d)

1 Answers  


NNC-00407: alias loop in name request

1 Answers  


ORA-31023: Index size error

1 Answers  


ORA-39020: invalid mode type string

1 Answers  


ORA-30202: NULL pointer to OCIMsgh was passed to OCIMsg function

1 Answers  


SQL-02106: Inconsistent cursor cache. Invalid Oracle cursor number

1 Answers  


ORA-31665: mode can only be defaulted for IMPORT and SQL_FILE operations

1 Answers  


NCR-04008: NCRR: Procedure exists

1 Answers  


Categories