Home » SQL & PL/SQL » SQL & PL/SQL » problem in enabling and disabling constraints
problem in enabling and disabling constraints [message #241590] Wed, 30 May 2007 02:12 Go to next message
v.ram81
Messages: 50
Registered: April 2006
Location: pune
Member

hi all,
i am having a table as test_master (test_no number not null,
test_desc varchar2(30) not null)
test_no is not null constraint.
it already has some records.
but somebody has disables the null constraints
and some records where get inserted into table with test_no as
null.
now i want to retain that (null) records and also to enable the
null constraints.
but now it is giving me error.
can anybody tell me is this possible ?
can we enable null constraint having null columns?

thanks in advance
regards
ram.

Re: problem in enabling and disabling constraints [message #241598 is a reply to message #241590] Wed, 30 May 2007 02:36 Go to previous messageGo to next message
pablolee
Messages: 2836
Registered: May 2007
Location: Scotland
Senior Member
Check out ENABLE NOVALIDATE
Re: problem in enabling and disabling constraints [message #241954 is a reply to message #241598] Thu, 31 May 2007 03:13 Go to previous message
v.ram81
Messages: 50
Registered: April 2006
Location: pune
Member

thank you ..
Previous Topic: Equivalent of set commands in oracle.....?
Next Topic: Get a field from a Record Type (merged)
Goto Forum:
  


Current Time: Sat Dec 10 03:07:32 CST 2016

Total time taken to generate the page: 0.08514 seconds