I have 4 tables from a source database. Each table has 20 columns.
I have 4 tables from a source database. Each table has 20 columns.
Using Oracle Streams, I would like to take 10 columns from each table and use Oracle Streams to be able to populate those columns into a target database.

But in the target database, I would like to join all those columns
from the 4 tables (taken from the source database) and make them into one single table in the target database.

Is this possible using streams? If not what alternative do I have?
I would also like to have the ability to modify,update,delete data
from this new table in the target database.

Tee