| Unique constraint [message #979] |
Mon, 18 March 2002 01:12  |
Alice
Messages: 2
Registered: March 2002
|
Junior Member |
|
|
Executing this statment:
update Table1
set pp_ids = null
where ids = 4900000000
I have error ORA-01407 "Cannot update Table1.pp_ids to NULL"
On this field is only foreign constraint and unique constraint, that is in ENABLE NOVALIDATE statuss, but there is no one NOT NULL constraint.
Question is because I cant update field pp_ids to NULL?
help me !!!
|
|
|
|
| Re: Unique constraint [message #997 is a reply to message #979] |
Tue, 19 March 2002 11:25  |
Giri
Messages: 12
Registered: March 2002
|
Junior Member |
|
|
Hi,
I created the same scenario, I am able to update the unique constraint column with NULL. First point if the value is null no constraints will be enforced, other than primary key and not null constraint. Check, by mistake you might have created primary key instead of unique key.
Giri.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
