Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Insert into snapshot table Oracle 8.1.7

Insert into snapshot table Oracle 8.1.7

From: William Vollenweider <wvollenw_at_bellsouth.net>
Date: Mon, 12 Nov 2001 18:50:31 -0500
Message-ID: <3BF06047.B11E8C3C@bellsouth.net>


Currently in 8.0.5 I have a read only simple snapshot. Using this version of the product I was able to insert data into the SNAP$ or snapshot table after building the snapshot. Basically, I was allowed to insert data into the snpashot on the remote site and the data was not replicated back to the master site. Testing this same process in 8.1.7 I am recieving an error, "ORA-01732: data manipulation operation not legal on this view ". After looking around it looks like the internal object definitions in 8.1.7 are a little different. Is there anyway to configure replication so that I can make changes on the remote site that do not get replicated back to the master site? I do need inserts, updates, and delete from the master site to be replicated to the remote site. Received on Mon Nov 12 2001 - 17:50:31 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US