alter table BPEL_XML_DATA add DATA blob;

update BPEL_XML_DATA bxd set DATA=(select BIN_DATA from LARGE_DATA where id = bxd.ldata_id);
delete from LARGE_DATA ld where ld.id in (select ldata_id from BPEL_XML_DATA);
alter table BPEL_XML_DATA drop column ldata_id;

alter table BPEL_XML_DATA add SIMPLE_VALUE varchar2(255);