alter table cr_revisions
drop constraint cr_revisions_lob_fk;

alter table cr_revisions
add constraint cr_revisions_lob_fk
foreign key (lob) references lobs on delete set null;