Re: Can VIEWs be REPLICATED

Andy Hardy <aph_at_ahardy.demon.co.uk> wrote:

>Hi,
 

>We're looking at using the Oracle database replication facilities and
>are wondering if it is possible to replicate views in the same ways as
>tables.
 

>Thoughts?

Yes, I currently have replication in place through views defined in a second database. The views in the second database are defined on tables in yet another database. This configuration allowed me to access a database that only had SQL*Net V1 available from a database running Oracle 7.3 where only SQL*Net V2 was available. The intermediate database had both SQL*Net versions available.

I do not use snapshot logs on the replicated tables. I am not sure if snapshot logs are usable if replicating through a view but I would think so since a view only expands the selection criteria for the base table.

>Andy
>Andy Hardy (Internet: aph_at_ahardy.demon.co.uk, CIS: 100015,2603)
>PGP key available on request
>===============================================================
>When more and more people are thrown out of work, unemployment results.
> -- Calvin Coolidge

Frank Thomas
thomasf_at_daugherty.com Received on Wed Jan 22 1997 - 00:00:00 CST