Re: Oracle Incremental Back Up

From: Howard J. Rogers <howardjr_at_www.com>
Date: Wed, 24 Oct 2001 19:07:22 +1000
Message-ID: <3bd68290$0$9999$afc38c87@news.optusnet.com.au>

Oracle 9i has the 'merge' function (often called an 'upsert' -update if the record exists in database B, using values from database A. Otherwise, insert the record into database B using the record as stored in database A).

You mention no version (****please**** would people get into the habit of doing this ??!~?#*&@), so I don't know if that's appropriate to you or not.

Anything earlier than 9i, it can't be done, short of writing some very fancy code.

Regards
HJR

--

Oracle Resources : http://www.geocities.com/howardjr2000
========================================


"Girish" <girish_bhat_at_yahoo.com> wrote in message
news:2dc1bfd.0110240047.329a95a3_at_posting.google.com...


> Hi,

>  Ive two databases which are exactly same in structure.One database is

> on my local Server and one on the ISP.Data is being entered on the

> Local as well as on the ISP server.Now,i want to post my local Server

> database data on to the ISP server database without my ISP data being

> overwritten i.e I want to append the new set of records from the local

> server to the ISP server.There is also an exceptional case where  a

> row is modified on the local server database.I want this modified row

> to replace the same row on the ISP database server.

>   Hope im clear with my problem.Can u plz help me out.

>

> Girish

Received on Wed Oct 24 2001 - 04:07:22 CDT