Oracle-L: 8i updateable snapshots

From: Ed <mrclark_at_xnet.com>
Date: Fri, 19 Jul 2002 07:38:28 -0800
Message-ID: <F001.0049C9FB.20020719073828@fatcity.com>

Oracle 8i (8.1.6):

Create a snapshot log on a table.

Create a basic snapshot on the table set to FAST FOR UPDATE.

What I want to do is update the slave table, without having the row overwritten by the next snapshot. I thought that by using FAST and a snapshot log, that the master wouldn't overwrite the slave unless the row in the master table changed again. We do not want the change in the slave table propagated back to the master table.

Here's what I want:

First snapshot created

Master Column: Slave Column:

Row: FORD FORD

2. Modify Slave Column:;;;;

Master Column: Slave Column:

Row: FORD FORD_NEW

3. Run Snapshot as Fast:

Master Column: Slave Column:

Row: FORD FORD_NEW

But what happens is that even though the row in the master table has NOT been changed, it overwrites the row in the slave table:

Master Column: Slave Column:

Row: FORD FORD

Don't ask WHY we have to do it this way... it wasn't based on my advice!

Thanks for any ideas.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Ed
INET: mrclark_at_xnet.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Jul 19 2002 - 10:38:28 CDT