FreeLists / oracle-l / Copying contents of table with varrays

["Buechi Martin" <Martin.Buechi@xxxxxxxxxx>]

All,

I have two databases containing a table T with a column of varray (of =
varchar2) type. What is the best way to copy the contents of this table =
between databases?

Database links don't work with varrays. Neither does TOAD's "Copy data =
to another schema". I am looking for a generic solution because I have n =
tables T1..Tn with varrays, I need to run this job once every couple of =
months, and the definition of the tables Ti may change from run to run.

I wrote a small Java proof of concept, but before I spend the time to =
polish it (e.g., addBatch doesn't seem to work properly in the presence =
of varrays), I would like to know whether such a solution already =
exists. Does it?

Any pointers are appreciated.

Regards,

Martin

------------------------------------------=20
A v a l o q - essential for banking=20
Avaloq Evolution AG=20
Allmendstrasse 140, 8027 Z=FCrich=20
T +41 44 488 6888, F +41 44 488 6868, <http://www.avaloq.com/>=20
Martin B=FCchi <mailto:martin.buechi@xxxxxxxxxx>=20

--
http://www.freelists.org/webpage/oracle-l