Copying contents of table with varrays

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_at_avaloq.com>=20

--

http://www.freelists.org/webpage/oracle-l Received on Tue May 03 2005 - 10:12:16 CDT