Re: Hw to replicate a view

From: Stephane Faroult <sfaroult_at_oriole.com>
Date: Sat, 13 Jan 2001 17:21:10 +0100
Message-Id: <10740.126622@fatcity.com>

--------------A23B0A9BBE94F39F751A511D
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Suganya wrote:

> Hi All
>      I want to replicate a view from one database to another.
> Reason I don't want to replicate as such the table contents with some
> business logic I want to replicate . While creating the repobject
> oname(object name)
> supports "View" whereas  generating the replication support
> does not allow "view".
> In crisp Hw to repliate a view in the advanced replication.
>
> Thanx and Regards
> Suganya
>

Suganya,

I am afraid you can't. Oracle replication is trigger-based, and triggers on views (INSTEAD OF triggers) are a 8i feature. I see two possibilities. Either you create your own log, INSTEAD OF trigger, job, etc. and mimic Oracle replication - IMHO it's a bit dangerous to mix your own replication with Oracle's. I presume that you must have a view at one end and a table at the other, otherwise you would replicate the underlying tables. The other way is to dump the contents of the view to a flat file, ftp and SQL*Loader. Not real time, but if you need a refresh twice a day at most it's quite doable.

Regards,

Stephane Faroult
Oriole Corporation

--------------A23B0A9BBE94F39F751A511D
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>

Suganya wrote:
<blockquote TYPE=CITE>Hi All
      I want to replicate a view from one database
to another.
 Reason I don't want to replicate as such the table contents with some
 business logic I want to replicate . While creating the repobject oname(object
name)
 supports "View" whereas  generating the replication support
 does not allow "view".
 In crisp Hw to repliate a view in the advanced
replication.
Thanx and Regards
 Suganya
  </blockquote>

Suganya,
    I am afraid you can't. Oracle replication is trigger-based,
and triggers on views (INSTEAD OF triggers) are a 8i feature.
 I see two possibilities. Either you create your own log, INSTEAD OF
trigger, job, etc. and mimic Oracle replication - IMHO it's a bit dangerous to mix your own replication with Oracle's. I presume that you must have a view at one end and a table at the other, otherwise you would replicate the underlying tables. The other way is to dump the contents of the view to a flat file, ftp and SQL*Loader. Not real time, but if you need a refresh twice a day at most it's quite doable.
Regards,
Stephane Faroult
 Oriole Corporation
  
Received on Sat Jan 13 2001 - 10:21:10 CST