Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Can VIEWs be REPLICATED
In article <32E544F3.124B_at_pp.kolumbus.fi>, Pauli Salmu
<pauli.salmu_at_pp.kolumbus.fi> writes
>Andy Hardy wrote:
>> 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?
>
>Sorry, but that leads to wonder whether you understand that a view
>doesn't store any data, it's only a definition.
Pauli,
I understand about views, but not how Oracle stores them and relates them to replicated tables.
I've now been informed that if the tables underlying a view are replicated, then so to will be the views.
Andy
Andy Hardy (Internet: aph_at_ahardy.demon.co.uk, CIS: 100015,2603)
PGP key available on request