Snapshot

[aji.thm]

HAI,

I am not able to create a updatable snapshot. I have an existing table at the master site. For this table there is no primary key. First I created snapshot log with rowid on the table at master site.

Now from the second site , i had issued the command

"create snapshot item_mst_snp as select * from item_mst@comn.world"
this gave an error
ORA-12028: snapshot type is not supported by master site

Does anybody has any idea about where i am making the mistake...?


...Thanks

[siroracle]

It might be that u have to set the snapshot to be refresh by ROWID the default is by primary key, but since u don't have one..it might be a problem ..so checkout the sintax of the create snapshot to set the ROWID refresh method.