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-29959: error in the execution of the string routine for one or more of the index partitions

1 Answers  


ORA-12609: TNS: Receive timeout occurred

1 Answers  


RMAN-06046: archive log name: string

1 Answers  


ORA-08432: raw data has invalid floating point data

1 Answers  


TNS-01053: Connecting to string

1 Answers  






LPX-00248: invalid entity declaration

1 Answers  


RMAN-06729: no backup of the SPFILE found to restore

1 Answers  


ORA-02439: Unique index on a deferrable constraint is not allowed

1 Answers  


ORA-31446: this session does not own the lock handle for string

1 Answers  


RMAN-07521: cannot create recovery catalog in database version string; version string required

1 Answers  


LPX-00660: Not a well-formed document or external entity.

1 Answers  


QSM-02064: subquery in mv

1 Answers  


Categories