Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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-29301: wrong DBMS_PITR package function/procedure order

1 Answers  


ORA-14508: specified VALIDATE INTO table not found

1 Answers  


PLS-00527: MAP or ORDER functions require a PRAGMA RESTRICT_REFERENCES specifying :WNDS,WNPS,RNPS,RNDS.

1 Answers  


SQL-02125: Connect error, can't get error text

1 Answers  


ORA-12158: TNS:could not initialize parameter subsystem

1 Answers  


ORA-06126: NETTCP: ORASRV unable to open network connection

1 Answers  


ORA-00208: number of controlfile names exceeds limit of string

1 Answers  


ORA-32336: cannot use USING NO INDEX to create materialized view "string"."string"

1 Answers  


ORA-00264: no recovery required

1 Answers  


UDI-00052: incorrect Data Pump client for operation: string

1 Answers  


ORA-39952: only numbers can be specified as range values

1 Answers  


ORA-16406: Primary and standby database software version mismatch

1 Answers  


Categories