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-02273: this unique/primary key is referenced by some
foreign keys

Answers were Sorted based on User's Feedback



ORA-02273: this unique/primary key is referenced by some foreign keys..

Answer / muzafar

Query to find the references

select * from all_constraints
where constraint_type='R' and
r_constraint_name='YOUR_CONSTRAINT_NAME';

OR DROP THE PRIMARY AND FORIGN KEY WITH THIS COMMAN

Query to find the references

alter table InISMast drop primary key cascade;

Is This Answer Correct ?    4 Yes 2 No

ORA-02273: this unique/primary key is referenced by some foreign keys..

Answer / guest

Cause: Self-evident.

Action: Remove all references to the key before the key is
to be dropped.

Please add more information about this Error

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-00484: LMS* process terminated with error

1 Answers  


ORA-01212: MAXLOGMEMBERS may not exceed string

1 Answers  


In VB program, I got message as " No Transaction is Active" , Backend database is Oracle, This message is coming some user's PC and Not all user's PC Please help me to resolve this issue

2 Answers  


ORA-22852: invalid PCTVERSION LOB storage option value

1 Answers  


NZE-28788: user provided invalid information, or an unknown error

1 Answers  


PCC-02404: This indicator variable must be declared as a pointer type

1 Answers  


ORA-27041: unable to open file

1 Answers  


PLS-00462: nested subprogram 'string' has to be REPEATABLE

1 Answers  


ORA-30055: NULL snapshot expression not allowed here

1 Answers  


ORA-07444: function address string is not readable

1 Answers  


ORA-23620: bind value size too large for PL/SQL CALL operation

1 Answers  


ORA-31456: error executing a procedure in the DBMS_CDC_UTILITY package

1 Answers  


Categories