connect to a schema in db1, create a db link to b schema in db2 named oracle_database2 and then
insert into table1 select * from table2@oracle_database2 one db handle, one connection within perl, assuming tables are the same.. use append hint to do direct load insert bypassing evaluation buffer going to straight to disk, assuming you have no referential integrity constraints on the table being loaded to. otherwise must drop them or use conventional load path (no append hint) job -----Original Message----- From: Sterin, Ilya [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 10:12 PM To: 'Tim Bunce'; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: (Fwd) Do you know how to select * from a.table1@oracle_database1 then insert them into b.table2.@oracle_database2 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 ----- > _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com
