LONG's and CLOB's

I am trying to populate a table with data from another table. The source table has a LONG field. I have transferred the data using the SQL*Plus COPY command (since "insert ... select ..." doesn't work for LONG's).

To be able to copy the LONG fields I have done a: set LONG 30000
All data from the LONG fields got through, but it has a lot of junk appended to it (it looks like LONG fields have been padded with some characters up to length 30000). How can I avoid that? If I don't do the set LONG 30000, the LONG fields are truncated to 80 characters.

My other question is how can I populate CLOB fields from LONG fields (COPY complained about type mismatch).

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Oct 05 1999 - 13:34:51 CDT