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
> Do you know how to select * from a.table1@oracle_database1 > then insert them into b.table2.@oracle_database2 Depending on the size of the tables, this may be one of the times SQL*Plus would be better than DBI. I had very good success with multimillion row tables using the SQL*Plus copy command. -- Mac :}) ** I normally forward private questions to the appropriate mail list. ** Ask Smarter: http://www.tuxedo.org/~esr/faqs/smart-questions.html Give a hobbit a fish and he eats fish for a day. Give a hobbit a ring and he eats fish for an age.
