Hello!
I need to transfer the contents of large CLOBs between Oracle database on different machines.
On the source machine, I use SQL Developer to run a query such as
select IDCOL, CLOBCOL.... from table1 where....
and then export the data to some text file, transfer the text file to another computer and use SQL Developer to import the data into the target database.
This works OK when the CLOB contains no more than 4000 chars. Otherwise, the contents are truncated.
I tried exporting to an XML file -- the standard export wizard includes XML as an option. The entire CLOB is exported.
On the target machine, however, SQL Developer does not import the XML! It has an option for XML files but an error message appears - 'There are no readers registered for the xml type.'
Both copies of SQL Developer are version 4.0. I've even tried importing the same XML file in the copy of SQL Developer that produced the file and see the same message!
1) Can we consider this a bug and ask someone to look at it?
2) What's the best way to transfer data from a SQL Developer data grid when there are CLOBs of 20k bytes? (On some systems that I use, I don't have access to the data pump.)