Subject Copy entire records without specifying the fields? IB_Datapump?
Author John vd Waeter
Hi Group,

I want to copy records from tables in database A to tables in database
B. Both databases have the same structure. Records in source_table do
not exist in destination_table.

Is there a way to read a record from A.table and subsequently insert it
in the corresponding B.table regardless of the recordstructure (which is
the same in both tables) ?

I have about 30 tables to process this way and somehow I think I
shouldn't write 30 different SELECT and corresponding INSERT statements
specifying all fields etc.

Can/should I use IB_Datapump?