Cause: An attempt was made to drop or replace a type that has dependents.

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

Question Posted / guest

1 Answers
6061 Views
I also Faced
E-Mail Answers

Answer Posted / 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 View All Answers

Please Help Members By Posting Answers For Below Questions

[ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) Unsuccessful: alter table user.CEN_USER_MASTER add constraint FKF4EDEDC3D0BAAE75 foreign key (ROLE_ID) references user.CEN_ROLE_MASTER [ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) ORA-02275: such a referential constraint already exists in the table

2678

IMP-00063: Warning: Skipping table "string"."string" because object type "string"."string" cannot be created or has different identifier

2682

ORA-16627: No standby databases support the overall protection mode.

3932

if the lengths of two wires are same and the area of cross sections is 4:7 then what will be the ratio of current passing through these wires

2645

ORA-26032: index string.string loading aborted after string keys

2053

NZE-28868: Peer certificate chain check failed.

2744

In my project I am using star schema and only diimension tables are loaded and not fact tables any one can help me why it is happening? Plase guide me.

2798

IMP-00060: Warning: Skipping table "string"."string" because object type "string"."string" does not exist or has different identifier

3102

RMAN-05017: no copy of datafile number found to recover

2345

IMP-00096: Warning: Skipping table "string"."string" because type synonym "string"."string" cannot be created

1561

IMP-00064: Definition of LOB was truncated by export

6349

ORA-26027: unique index string.string partition string initially in unusable state

6699

ORA-26076: cannot set or reset value after direct path structure is allocated

1900

ORA-26094: stream format error: input column overflow

2736

ORA-26079: file "string" is not part of table string.string

1894