In two tables I have a column called table1.column_xml and table2.column_xml_2 defined as CLOB(1000000). The fields in the column contain XML formatted information like below
column_xml
--------------------------------------------------------------------------------
<values>
<comment>test test test</comment>
<rights></rights>
<title>TEST MAN</title>
</values>
--------------------------------------------------------------------------------
What I would like to do is import/or replace any existing values in table2.column_xml_2 with the values from table1.column_xml.
So in simpler terms I want to export the values from column_xml into a file then import/replace into column_xml_2