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;

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

DRG-12211: section or section id string does not exist

1 Answers  

---

ORA-24810: attempting to write more data than indicated

1 Answers  

---

ORA-10580: Can not modify datafile header during test recovery

1 Answers  

---

ORA-15021: parameter "string" is not valid in string instance

1 Answers  

---

TNS-12661: Protocol authentication to be used

1 Answers  

---

LPX-00113: element "~1S" ID attribute "~2S" must be #IMPLIED or #REQUIRED

1 Answers  

---

ORA-27458: A program of type PLSQL_BLOCK cannot have any arguments.

1 Answers  

---

ORA-20000: %s

1 Answers  

---

ORA-02094: replication option not installed

1 Answers  

---

ORA-24089: AQ Agent string already exists

1 Answers  

---

ORA-16091: dependent archive log destination already archived

1 Answers  

---

RMAN-06058: a current controlfile cannot be included along with a standby controlfile

1 Answers  

---