Re: Insert into snapshot table Oracle 8.1.7

Hi!

William Vollenweider writes:

> 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.

You can call DBMS_SNAPSHOT.SET_I_AM_A_REFRESH(true) before doing DML on the snapshot and DBMS_SNAPSHOT.SET_I_AM_A_REFRESH(false) when you are done. This will disguise the current session as a refresh process and allow changes to the snapshot.

Of course the SET_I_AM_A_REFRESH procedure is completely undocumented and as always the use and abuse is unsupported by Oracle.

-- 
Stefan