#1 09 Oct 2011 09:21

drrao
Member
Registered: 09 Oct 2011
Posts: 1

how to alter check constraint in oracle

how to alter check constraint in oracle


alter table
   table_name
add constraint
   check_constraint_name
   CHECK
   (check_column_name IN
      (
       'check_constraint1_value',
       'check_constraint2_value',
       'check_constraint3_value',
       'check_constraint4_value'
      )
   ) DISABLE|ENABLE;

But i want with out using alter
Give me solution



Thank you
Regards
Dronadula

Offline

#2 09 Oct 2011 11:27

Simon Sheppard
Super Administrator
Registered: 27 Aug 2005
Posts: 873
Website

Re: how to alter check constraint in oracle

If you want to alter the table without checking/altering the existing data look at the NOVALIDATE clause
http://ss64.com/ora/syntax-constraints.html#validate

Offline

Board footer

Powered by FluxBB