-
ORA-01407 Error
I am trying to run the following query and I get the error listed below. I cannot disable the Not NULL contraint, and I have verified that neither of the tables DFU tables contain null values in the DISC column. Any ideas would be apprecited.
update dfu a
set a.disc = (select b.disc
from dfu@MANPROD.RAR.NCSUS.JNJ.COM b
where a.dmdunit = b.dmdunit
and a.dmdgroup = b.dmdgroup
and a.loc = b.loc)
The following error has occurred:
ORA-01407: cannot update ("STSC"."DFU"."DISC") to NULL
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|