Message-Id: <10740.126622@fatcity.com> From: Stephane Faroult Date: Sat, 13 Jan 2001 17:21:10 +0100 Subject: Re: Hw to replicate a view --------------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 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