Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-02273: this unique/primary key is referenced by some
foreign keys
- 2 Answers
- 21472 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 |
DRG-52203: invalid object name: string
ORA-06303: IPA: Message send error
IMG-00550: invalid scanlineOrder specified
PCC-02390: No EXEC SQL CONTEXT USE statement encountered
RMAN-08091: channel string: specifying datafile(s) for proxy backup
ORA-03207: subpartitioned type must be specified for composite object
ORA-13449: GeoRaster metadata ULTCoordinate error
ORA-30364: this level has the same set of columns as another
ORA-31466: no publications found
ORA-01670: new datafile string needed for standby database recovery
PCC-02380: Cannot specify a connect mode when altering a user password
EXP-00019: failed to process parameters, type 'EXP HELP=Y' for help
Oracle Errors 
