COPY FROM user/password@prod_db TO user/password@dev_db -
INSERT TABLE_A (COL1,COL2,COL3,BLOB_COL) USING -
SELECT COL1,BLOB_COL -
FROM TABLE_A WHERE COL1='KEY'

CREATE DATABASE LINK link_to_prod CONNECT TO prod_user IDENTIFIED BY prod_password USING 'prod_db';

INSERT INTO TABLE_A@link_to_prod (COL1,BLOB_COL) SELECT COL1,BLOB_COL FROM TABLE_A