Oracle: workaround for snapshots on tables with LONG columns?

Question

Do i need to write in PL/SQL or is it possible in SQL query?

Answer 1

ou can use the SQL*Plus COPY command instead of snapshots if you need to copy
LONG and LONG RAW variables from one location to another. Eg:

COPY TO SCOTT/TIGER@REMOTE -
CREATE IMAGE_TABLE USING -
SELECT IMAGE_NO, IMAGE -
FROM IMAGES;

Note: If you run Oracle8, convert your LONGs to LOBs, as it can be replicated