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


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

IMG-00720: image processing internal error

1 Answers  


NNL-00042: LDAP bind failure: number, string

1 Answers  


PLS-01502: Constraint name and constraint status are non-ANSI.

1 Answers  


ORA-16577: corruption detected in Data Guard configuration file

1 Answers  


ORA-31420: unable to submit the purge job

1 Answers  






TNS-00286: Max Connect Time (secs) : number

1 Answers  


ORA-13861: Statistics aggregation for client identifier string is already enabled

1 Answers  


ORA-16133: Datafile string has incorrect terminal recovery stamp.

1 Answers  


ORA-02267: column type incompatible with referenced column type

1 Answers  


LFI-01520: close() failed(OSD return value = string) in string.

1 Answers  


ORA-25295: Subscriber is not allowed to dequeue buffered messages

1 Answers  


RMAN-06553: DB_CREATE_FILE_DEST must be set for SET NEWNAME ... TO NEW

1 Answers  






Categories