ORA-02273: this unique/primary key is referenced by some
foreign keys
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-06260: NETNTT: cannot write to remote process
TNS-00262: %20sstringnumber
NNL-00501: set|show log_stats_interval [<seconds>] [<server_list>] : set|show the server's statistic counter logging interval
ORA-28172: distinguished name not provided by proxy
TNS-00243: Connection Manager: Tracing is now OFF
ORA-01237: cannot extend datafile string
ORA-25139: invalid option for CREATE TEMPORARY TABLESPACE
DRG-12202: error while creating section group
ORA-12673: Dedicated server: context not saved
ORA-28105: cannot create security relevant column policy in an object view
ORA-16209: Logical standby dictionary build failed to complete.
ORA-09758: osnipn: could not check port in name server.