Re: Help: how to convert long to clob or something else ?

Oracle has sample code that involves writing the data out to disk and importing it into CLOB's. Another option is to use the chunking functions (DBMS_LOB with VARCHAR's as intermediates w/32k data chunks).

• Webb

PS: You might want to try using the SQL+ copy command - I'm not sure what the implementation of that is, but who knows?

sv <vss10_at_topmail.de> wrote in message news:72okqs$ihs$1_at_goof.de.uu.net...
>Hi,
>
>i have problems to convert several tables which contain long columns. I
have
>to concat these tables to one big table.
>Oracle does not allow any insert operations on these tables in combination
>with select statements in the insert clause.
>
>By the way, is there any possibility to convert long columns into clobs ???
>
>
>Thanks
>
>Stephan
>
>
Received on Tue Nov 17 1998 - 17:57:39 CST