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

ORA-08209: scngrs: SCN not yet initialized

1 Answers  

---

ORA-28519: no heterogeneous data dictionary translations available

1 Answers  

---

ORA-27002: function called with invalid device structure

1 Answers  

---

EXP-00077: multiple output files specified for unbounded export file

1 Answers  

---

ORA-09367: Windows 3.1 Two-Task driver unable to deallocate shared memory

1 Answers  

---

QSM-02120: compatibility mode must be 9.0 or higher

1 Answers  

---

ORA-16766: Physical apply service unexpectedly offline

1 Answers  

---

PLS-00428: an INTO clause is expected in this SELECT statement

1 Answers  

---

IMP-00020: long column too large for column buffer size (number)

1 Answers  

---

NZE-28757: system attempt to allocate 0 bytes of memory

1 Answers  

---

DRG-50901: text query parser syntax error on line string, column string

1 Answers  

---

SQL*Loader-00251: Sort devices are not used by SQL*Loader

1 Answers  

---