Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-02273: this unique/primary key is referenced by some
foreign keys
- 2 Answers
- 21467 Views
- KIIT, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
ORA-29366: invalid CONSUMER_GROUP argument specified
ORA-07480: snchmod: cannot change permissions on ?/dbs/sgalm.dbf.
ORA-19622: archivelog thread string sequence string not restored due to string
PLS-00901: the data type of column 'string' of table 'string' is not supported
EXP-00017: feature "string" is needed, but not present in database
NNL-00400: Response status:
ORA-28010: cannot expire external or global accounts
ORA-25282: message id. not provided for non-repudiation
TNS-04088: Unable to close atleast one of the connections.
RMAN-08159: executing global script: string
RMAN-10012: KGU error: string
ORA-38408: The ADT "string" does not exist in the current schema.
Oracle Errors 
