Can you provide the version of Oracle DB and perhaps a DESC or CREATE TABLE for the tables involved? It would make it much easier to provide some thoughts or help. On Thu, Jun 27, 2013 at 11:09 AM, Denise Gwinn <denise@xxxxxxxxxxxxxx>wrote: > I have to merge some tables that contain a long datatype. A simple > insert into tableA (select * from tableB) will not work. I've tried > Googling, but not having much success. Could someone enlighten me please? > -- > //www.freelists.org/webpage/oracle-l > > > -- Don Seiler http://www.seiler.us -- //www.freelists.org/webpage/oracle-l