SQL & PL/SQL

Hi,

i want to migrate some data so i want to disable and then enable constraints

so i am following.
step 1
ALTER TABLE dept
DISABLE CONSTRAINT dname_ukey;

step2
ALTER TABLE dept
ENABLE NOVALIDATE CONSTRAINT dname_ukey;

step3
ALTER TABLE dept
MODIFY CONSTRAINT dname_key VALIDATE;

Q1)my doubt is can i write
ALTER TABLE dept
ENABLE CONSTRAINT dname_ukey;
in step3 and which one is better when compaired to above.

Q2) disabling constraint drops indexs
so does enabling Constantin creates them.

Q3) how can i find non existence of index of any disabled constraint.


note: i have four types P,R,U,C Types of constraints.

yours sincerely

Edited by: 944768 on Dec 24, 2012 10:51 PM