Ok... Some thoughts... What's the underlying faliure that caused the 3113? What happens if you just try and copy the remote table to a local table and then merge between the two local tables? Tim Rachel Carmichael wrote: >I'm testing an update process using MERGE. For reasons too complicated >to go into (can you say "corporate politics"?) I have a login app in >one database and the "real" admin users tables in another database. The >users don't want to use database links to read the admin table >real-time, they worry about the possibility of one database being down >for maintenance and hanging up the second app. So I've got copies of >the real tables in the login database. > >Clear as mud so far? > >Now I have to update the tables in the login database with the real >data on a regular basis. I *could* set up replication, but these are >tiny tiny TINY tables (I might have 34 rows in the largest one) and >it's just not worth the effort. > >So I thought, use a database link to get the real data and use MERGE to >get the data in. I get to play with a new command I've never used and >pretend to be a real 9i DBA. First run through, so it should all be >the INSERT part of the MERGE command. > >Works like a charm on the 5 row table. > >I keep getting "end of file on communication channel" on the 34 row >table. This happens within 5 seconds of hitting enter. > >9.2.0.2 on Sun Solaris. For testing purposes, I'm actually linking back >into the same database, different schema, via a dblink. > >I've looked at Metalink, the docs and even a bit into Tom Kyte's site >(thanks Paul).... nothing. > >Any suggestions on where I should look next? > >I *could* just truncate and reload but the users are paranoid about the >truncate happening and then not being able to reload and being left >with no admin data > >Rachel > > > > > > >__________________________________ >Do you Yahoo!? >Win a $20,000 Career Makeover at Yahoo! HotJobs >http://hotjobs.sweepstakes.yahoo.com/careermakeover >---------------------------------------------------------------- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >---------------------------------------------------------------- >To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx >put 'unsubscribe' in the subject line. >-- >Archives are at //www.freelists.org/archives/oracle-l/ >FAQ is at //www.freelists.org/help/fom-serve/cache/1.html >----------------------------------------------------------------- > > -- Regards, Tim Johnston Tel: 978-322-4226 Fax: 978-322-4100 ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------