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-16771: Converting physical standby to primary failed in the failover operation.

1 Answers  


PLS-00382: expression is of wrong type

1 Answers  


ORA-38610: FI "string" name prefix is reserved for frequent itemset counting

1 Answers  


ORA-19860: piece validation cannot be performed more than once

1 Answers  


NNO-00852: failed to get LDAP entry: error = number

1 Answers  






PLS-01708: In searched DELETE, UPDATE or INSERT, table must not appear in FROM clause of subqueries in search condition

1 Answers  


ORA-31201: DBMS_LDAP: generic error: string

1 Answers  


EXP-00031: Arraysize not in valid range. Using arraysize=number

1 Answers  


ORA-28558: HS_FDS_CONNECT_STRING undefined for non-Oracle system

1 Answers  


ORA-14325: only LOCAL indexes may be specified in this clause

1 Answers  


ORA-02701: osnoraenv: error translating oracle image name

1 Answers  


IMP-00004: invalid username or password

1 Answers  


Categories