http://otn.oracle.com/doc/server.815/a66736/ch63.htm#307
José. -----Original Message----- From: Michael A Chase [mailto:[EMAIL PROTECTED]] Sent: Friday, April 19, 2002 7:03 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: (Fwd) Do you know how to select * from a.table1@oracle_database1 then insert them into b.table2.@oracle_database2 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. **** DISCLAIMER **** "This e-mail and any attachment thereto may contain information which is confidential and/or protected by intellectual property rights and are intended for the sole use of the recipient(s) named above. Any use of the information contained herein (including, but not limited to, total or partial reproduction, communication or distribution in any form) by other persons than the designated recipient(s) is prohibited. If you have received this e-mail in error, please notify the sender either by telephone or by e-mail and delete the material from any computer". Thank you for your cooperation. For further information about Proximus mobile phone services please see our website at http://www.proximus.be or refer to any Proximus agent.