kishore.giri

 Profile Answers by kishore.giri Questions by kishore.giri

• Dec 10th, 2007

 

Dear Shruti,
First query the data dictionary view "USER_CONS_COLUMNS" to find the constraint name.
Then instead of dropping the constraint just disable it.

step1:--> select constraint_name,column_name from user_cons_columns where table_name='TABLE_NAME'

n.b: please give the table_name in capital letters;
step-2--> disbale the constraint using the following command.

alter table table_name disable constraint constraint_name;

try it and reply