RE: merge command
- From: "Richard Ji" <Richard.Ji@xxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 6 May 2004 14:51:15 -0400
Bug maybe? Does an ORA 7445 happens when the ORA 3113 occurs?
Can you try 9.2.0.5?
Richard Ji
-----Original Message-----
From: Rachel Carmichael [mailto:wisernet100@xxxxxxxxx]
Sent: Thu 5/6/2004 2:02 PM
To: freelists oracle-l
Cc:
Subject: merge command
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
-----------------------------------------------------------------
-- Binary/unsupported file stripped by Ecartis --
-- Type: application/ms-tnef
-- File: winmail.dat
----------------------------------------------------------------
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
-----------------------------------------------------------------
Other related posts:
