Yes, you'd want to make two database connections, and once you have two database handles, you use one to select, the other to insert, then close both. For more technical details please read perldoc DBI.
Ilya > -----Original Message----- > From: Tim Bunce [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 18, 2002 5:54 PM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: (Fwd) Do you know how to select * from > a.table1@oracle_database1 then insert them into > b.table2.@oracle_database2 > > > ----- Forwarded message from "Sabol, Sue Z." > <[EMAIL PROTECTED]> ----- > > Delivered-To: [EMAIL PROTECTED] > From: "Sabol, Sue Z." <[EMAIL PROTECTED]> > To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> > Subject: Do you know how to select * from > a.table1@oracle_database1 then > insert them into b.table2.@oracle_database2 > Date: Thu, 18 Apr 2002 17:20:40 -0400 > > Dear Tim, > > Do you know how to select * from a.table1@oracle_database1 > then insert them into b.table2.@oracle_database2 > > Thanks! > > > ----- End forwarded message ----- >
