Re: Usage of snapshots

On the target database (production in your case) snapshot will be not updatable. You can make it updatable though, it'll update source database in this case. You can't create snapshot with the same name as a table on a target instance in the same schema. May be all you need is a database link to other database?

In article <7cj5de$qho$1_at_nnrp1.dejanews.com>,   m-rao_at_mailcity.com wrote:
> Hi All
>
> Can someone clarify me in using snapshots in a distributed environment We
> Have production database as well as development database and we are thinking
> of implementing snaphots mechanism in production database to refelect the
> data for few tables from development database. My doubdt is will the snapshot
> will be replacing actual table in destination or is there any other way
> through which we can have a linking facility of snapshot to the base table.
> Will it be possible to do the entire process without writing any procedures.
> Or can we implement in such a way by creating snapshot log and by reading
> this we can reflect changes to the table in a procedural way. Please suggest
> me in implementing snapshots for a existed distributed database.
>
> Thanks in advance
> Madhukar Rao
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Mar 15 1999 - 20:38:02 CST