I need to impliment Oracle Streams in a single Database (Source and Destination are same--Single Database).

I have four Diferent schemas in this database -- These are like source schemas. There are two other different schemas which we need to replicate them.

i need to replicate some selected tables from each Schema (some selected columns in each table), and replicate it
with other different schema which is also resides in the same database.

Table structure is different. so i need to select some columns only.

If you have any ideas please let me know. Thanks in advance.

If you have any documentation please post here.