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-06320: IPA: Remote maximum number of connections exceeded

1 Answers  


PLS-00117: Duplicate connect-by clause in table expression

1 Answers  


RMAN-20010: database incarnation not found

1 Answers  


DRG-11513: unable to open or write to file string

1 Answers  


DRG-50802: failed to bind input

1 Answers  


ORA-31444: parameter error while acquiring lock on string

1 Answers  


NZE-28798: Number of sub-keys application passes to bind does not match that in the key.

1 Answers  


ORA-24048: cannot create QUEUE_TABLE, user does not have access to AQ object types

1 Answers  


ORA-12091: cannot online redefine table "string"."string" with materialized views

1 Answers  


SQL*Loader-00703: Internal error: argument number

1 Answers  


ORA-29268: HTTP client error string

1 Answers  


ORA-01422: exact fetch returns more than requested number of rows

1 Answers  


Categories