appears to be a bug in 9i, fixed in 10g (thanks for testing Pete!)
turned out that one of the columns in the original table was defined
larger than the same column in the table I was merging into.... soon as
I made them the same, problem went away.
The error message is misleading.... I got logged off and a 3113
end-of-file on communication channel. In 10g you get a message that
the column is the wrong size (I can't remember the exact error message)
Thank you to everyone for your suggestions. works beautifully now
Rachel
- Rachel Carmichael <wisernet100_at_yahoo.com> 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_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
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_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Thu May 06 2004 - 20:05:42 CDT
