Replicate VIEW

[zerolovebell]

hi, i am working on something that i think replication might be the right approach.

oki, here's the scenario:
our customer database is hosted and maintained by us. Recently, the customer wanted copy of the daily transaction data to be ported over to their office file server/ database at a scheduled time daily. As the database design ownership belongs to us, i cannot replicate the entire schema over to the customer's own database.

My approach is to create VIEWS from mulitple tables. Then replicate these VIEWS to my customer's own database. So, only the VIEWS get replicated over. This will allows me to retain the original schema design in our own database while serving a FLAT-Design VIEWS to the customer own database.
All this replication activities will be executed across a lease line.

do you think this will work? Thanks

rgds
AiLing

[stecal]

Views would definitely be feasible, and you may want to consider materialized views at that.
http://download-west.oracle.com/docs...m.htm#CNCPT411