update archive.PCET_INFO@REC_ARCHIVE a
set a.infodata=
(select b.infodata from archive.PCET_INFO  b where a.INFOID=b.INFOID )