Question: how to copy blob data from one table to another in oracle?
Answer: SYS@TCDB1 > create table source (id int, val int);
Table created.
SYS@TCDB1 > create table dest (id int, val int);
Table created.
SYS@TCDB1 >
insert into source values (1,1);
1 row created.
SYS@TCDB1 > insert into source values(2,2);