<div>
<div class="content wysiwyg-content">
Hi, <br />
<br />
I need to replicate the data from oracle views (master_schema)to &nbsp;tables in another schema(Rep_schema) (in the same database). <br />
1) Can oracle streams be used for replicating data from oracle view to a oracle table?<br />
<br />
Also if the data got deleted from base tables of oracle views (in master_schema) then the data should not get deleted in the tables of Rep_schema. Only update and inserts should replicate to the rep_schema.<br />
<br />
2) Can this be achieved with &nbsp;Fast refresh MV ? (I think we cannot. just I want to confirm)<br />
3) Can this be achieved with oracle steams setup?<br />
<br />
<br />
Thanks<br />
<br />
<br />
<br />
.
</div>
</div>


Hi, 

I need to replicate the data from oracle views (master_schema)to  tables in another schema(Rep_schema) (in the same database). 
1) Can oracle streams be used for replicating data from oracle view to a oracle table?

Also if the data got deleted from base tables of oracle views (in master_schema) then the data should not get deleted in the tables of Rep_schema. Only update and inserts should replicate to the rep_schema.

2) Can this be achieved with  Fast refresh MV ? (I think we cannot. just I want to confirm)
3) Can this be achieved with oracle steams setup?


Thanks



.

Oracle streams

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.