Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Insert into snapshot table Oracle 8.1.7
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