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-30118: syntax error at 'string' at the end of input

1 Answers  

---

ORA-02203: INITIAL storage options not allowed

1 Answers  

---

ORA-30379: query txt not specified

1 Answers  

---

EXP-00012: %s is not a valid export mode

1 Answers  

---

ORA-13144: target table string not found

1 Answers  

---

ORA-04031: unable to allocate string bytes of shared memory ("string","string","string","string")

1 Answers   Satyam,

---

TNS-00258: Number of Failed Requests : number

1 Answers  

---

NNL-01003: NON LEAF responses received: number

1 Answers  

---

NID-00130: Mismatched CHECKPOINT_CHANGE# in datafile "string", expecting string, found string

1 Answers  

---

ORA-16587: Ambiguous object specified to Data Guard broker

1 Answers  

---

ORA-02249: missing or invalid value for MAXLOGMEMBERS

1 Answers  

---

ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit

2 Answers  

---